timezone, how postgres deal with it?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: timezone, how postgres deal with it?
Date: 2012-11-22 15:36:42
Message-ID: 004701cdc8c7$3a5cf4b0$af16de10$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

timestamp with timezone just show/hide time zone?

thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-11-22 15:55:00 Re: timezone, how postgres deal with it?
Previous Message Gnanakumar 2012-11-22 06:03:19 Re: Database archive solutions