Re: timezone offsets and documentation

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: timezone offsets and documentation
Date: 2005-02-07 09:30:20
Message-ID: Pine.BSO.4.56.0502070428400.30515@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, 6 Feb 2005, Tom Lane wrote:

> Kris Jurka <books(at)ejurka(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Florian Hars 2005-02-07 12:06:13 BUG #1467: fe_connect doesn't handle EINTR right
Previous Message Niklas Andersson 2005-02-07 08:28:53 bug: erroronous ret-value for system() call in 2.6-kernel