Re: timezone, how postgres deal with it?

From: Gary Chambers <gwchamb(at)gwcmail(dot)com>
To: Anibal David Acosta <aa(at)devshock(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timezone, how postgres deal with it?
Date: 2012-11-20 21:53:42
Message-ID: alpine.DEB.2.02.1211201651270.14205@bail
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)

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2012-11-20 22:06:54 Re: get column name passed to a function
Previous Message Anibal David Acosta 2012-11-20 21:48:22 timezone, how postgres deal with it?