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
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 |