Re: timezone, how postgres deal with it?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Anibal David Acosta" <aa(at)devshock(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: timezone, how postgres deal with it?
Date: 2012-11-22 15:55:00
Message-ID: 27540.1353599700@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Anibal David Acosta" <aa(at)devshock(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2012-11-22 16:05:49 Re: timezone, how postgres deal with it?
Previous Message Anibal David Acosta 2012-11-22 15:36:42 timezone, how postgres deal with it?