"Collin Peters" <[EMAIL PROTECTED]> writes:
> I have read the post and understand the issue. I am wondering why
> this is not mentioned in the documentation.
It is. Per
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html#DATATYPE-TIMEZONES
"One should be wary that the POSIX-style
Collin Peters escribió:
> I have read the post and understand the issue. I am wondering why
> this is not mentioned in the documentation. Or even worse why the
> PostgreSQL documentation explicitly lists all the timezones correctly
> in table B-4
> http://www.postgresql.org/docs/8.1/static/datet
I have read the post and understand the issue. I am wondering why
this is not mentioned in the documentation. Or even worse why the
PostgreSQL documentation explicitly lists all the timezones correctly
in table B-4
http://www.postgresql.org/docs/8.1/static/datetime-keywords.html#DATETIME-TIMEZON
On Friday 20 June 2008 1:19 pm, Collin Peters wrote:
> I have a server of which the OS timezone is set to Pacific time
> (currently -7). I run the following query on it
>
> SELECTnow(), now() AT TIME ZONE 'GMT+10:00', now() AT TIME ZONE
> 'GMT-10:00', now() AT TIME ZONE 'Australia/Melbourn
I have a server of which the OS timezone is set to Pacific time
(currently -7). I run the following query on it
SELECT now(), now() AT TIME ZONE 'GMT+10:00', now() AT TIME ZONE
'GMT-10:00', now() AT TIME ZONE 'Australia/Melbourne'
I would expect this to return:
* column 1 - the current time in