Postgres Pro
Downloads
Home   >   mailing lists

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

From Gary Chambers
Subject Re: timezone, how postgres deal with it?
Date
Msg-id alpine.DEB.2.02.1211201651270.14205@bail
Whole thread Raw
In response to timezone, how postgres deal with it?  ("Anibal David Acosta" <aa@devshock.com>)
Responses Re: timezone, how postgres deal with it?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> 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)

It's false for me, too.  Change '2012-11-20 18:00:00-03:00' to the correct '2012-11-20
16:00:00-03:00' and it will work as you expect.

--
G.

pgsql-general by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: timezone, how postgres deal with it?
Next
From: Rob Sargent
Date:
Subject: Re: get column name passed to a function