Re: timezone, how postgres deal with it? - Mailing list pgsql-admin

From Tom Lane
Subject Re: timezone, how postgres deal with it?
Date
Msg-id 27540.1353599700@sss.pgh.pa.us
Whole thread Raw
In response to timezone, how postgres deal with it?  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-admin
"Anibal David Acosta" <aa@devshock.com> writes:
> This query returns false
> select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) =
> ('2012-11-20 18:00:00-03:00'::timestamp with time zone)
> But are exactly same time

No, they aren't.  You're apparently still confused about the sign of
timezone offsets.  The first one corresponds to 19:00 GMT, the second
to 21:00 GMT.

BTW, why are you posting the exact same question you posted two days
ago on another list?

            regards, tom lane


pgsql-admin by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: timezone, how postgres deal with it?
Next
From: "Albe Laurenz"
Date:
Subject: Re: timezone, how postgres deal with it?