timezone, how postgres deal with it?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: timezone, how postgres deal with it?
Date: 2012-11-20 21:48:22
Message-ID: 011e01cdc768$c4fd1920$4ef74b60$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Why?

Does postgres convert the datetime or just show/hide time zone?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gary Chambers 2012-11-20 21:53:42 Re: timezone, how postgres deal with it?
Previous Message Adrian Klaver 2012-11-20 21:03:39 Re: get column name passed to a function