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
>
> 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 the pacific (-7) - "2008-06-20
> 13:09:39.245641-07"
> * column 2 - the GMT +10 - "2008-06-21 06:09:39.245641"
> * column 3 - the GMT -10 - "2008-06-20 10:09:39.245641"
> * column 4 - the current time in Melbourne Australia - "2008-06-21
> 06:09:39.245641"
>
> Instead it returns:
> * column 1 - the current time in the pacific (-7) ("2008-06-20
> 13:09:39.245641-07" - CORRECT)
> * column 2 - the current time MINUS 10 ("2008-06-20 10:09:39.245641" -
> WRONG) * column 3 - the current time PLUS 10 ("2008-06-21 06:09:39.245641"
> - WRONG) * column 4 - the current time in Melbourne Australia ("2008-06-21
> 06:09:39.245641" - CORRECT)
>
>
> Am I missing something obvious? Seems when I specify GMT+10:00 it
> returns GMT-10:00 and vice versa. Note that column 2 & 3 are
> timestamp withOUT timezone while 1 & 4 are timestamp WITH timezone.
> But I still see this as totally wrong.
>
> Regards,
> Collin Peters
See this message for the explanation:
http://archives.postgresql.org/pgsql-bugs/2008-04/msg00077.php
--
Adrian Klaver
aklaver@comcast.net