<!--

$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.80 2001/12/23 20:21:37 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.81 2001/12/29 18:35:46 thomas Exp $

-->

<chapter id="datatype">

</row>

<row>

<entry><type>interval</type></entry>

<entry><type>interval(<replaceable>p</replaceable>)</type></entry>

<entry></entry>

<entry>general-use time span</entry>

</row>

</row>

<row>

<entry><type>numeric(<replaceable>p</replaceable>, <replaceable>s</replaceable>)</type></entry>

<entry><type>decimal(<replaceable>p</replaceable>, <replaceable>s</replaceable>)</type></entry>

<entry><type>numeric [ (<replaceable>p</replaceable>,

<replaceable>s</replaceable>) ]</type></entry>

<entry><type>decimal [ (<replaceable>p</replaceable>,

<replaceable>s</replaceable>) ]</type></entry>

<entry>exact numeric with selectable precision</entry>

</row>

<entry>1 day</entry>

</row>

<row>

<entry><type>time [ without time zone ]</type></entry>

<entry><type>time [(<replaceable>p</replaceable>) ] [without time zone ]</type></entry>

<entry>times of day only</entry>

<entry>8 bytes</entry>

<entry>00:00:00.00</entry>

<entry>23:59:59.99</entry>

<entry>1 microsecond</entry>

</row>

<row>

<entry><type>time with time zone</type></entry>

<entry><type>time[ (<replaceable>p</replaceable>) ]with time zone</type></entry>

<entry>times of day only</entry>

<entry>12 bytes</entry>

<entry>00:00:00.00+12</entry>

<productname>PostgreSQL</productname> for legacy applications and

for compatibility with other RDBMS implementations).

<productname>PostgreSQL</productname>

assumes local time for any type containing only

assumesyourlocal time zone for any type containing only

date or time. Further, time zone support is derived from

the underlying operating system

time-zone capabilities, and hence can handle daylight-saving time