Quite some time ago, Kris Jurka <[EMAIL PROTECTED]> wrote:
> This allows:
> jurka=# set timezone to 'Etc/GMT-14';
> SET
> jurka=# select '00:00:00'::timetz;
>timetz
> -
> 00:00:00+14
> (1 row)
> but this is not an allowed value:
> jurka=# select '00:00:00+14'::timetz;
> ERRO
On Sun, 6 Feb 2005, Tom Lane wrote:
> Kris Jurka <[EMAIL PROTECTED]> 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.htm
Kris Jurka <[EMAIL PROTECTED]> 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 ...
regards, tom lane
---(end of broadcast)---
The documentation says the time with time zone datatype allows zone
offsets from +12 to -12.
http://www.postgresql.org/docs/8.0/static/datatype-datetime.html
This is at odds with the implementation which allows values +1359 to -1359
jurka=# select '00:00:00+1359'::timetz;
timetz
