| 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: | Whole Thread | Raw Message | 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 |