Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 ...

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group