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

Anibal David Acosta wrote:
> 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
>
> Why?

They are not the same.  Compare:

select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) =
('2012-11-20 16:00:00-03:00'::timestamp with time zone)

That will return true.

Yours,
Laurenz Albe