Re: timezone offsets and documentation - Mailing list pgsql-bugs

From Kris Jurka
Subject Re: timezone offsets and documentation
Date
Msg-id Pine.BSO.4.56.0502070428400.30515@leary.csoft.net
Whole thread Raw
In response to Re: timezone offsets and documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sun, 6 Feb 2005, Tom Lane wrote:

> Kris Jurka <books@ejurka.com> writes:
> > The documentation says the time with time zone datatype allows zone
> > offsets from +12 to -12.
>
> I see noplace that opines on this at all ...
>

http://www.postgresql.org/docs/8.0/static/datatype-datetime.html

The reference I provided shows Table 8-9 Date/Time Types:

time [ (p) ] with time zone    12 bytes    times of day only, with
time zone    00:00:00.00+12    23:59:59.99-12    1 microsecond / 14 digits

The low value/high value columns seem to me to indicate the +/-12 zone
offset range.

Kris Jurka

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: timezone offsets and documentation
Next
From: Dennis Bjorklund
Date:
Subject: Table name used as aggregate argument