Home > mailing lists

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

From	Anibal David Acosta
Subject	timezone, how postgres deal with it?
Date	November 21, 2012 00:48:26
Msg-id	011e01cdc768$c4fd1920$4ef74b60$@devshock.com Whole thread Raw
Responses	Re: timezone, how postgres deal with it? Re: timezone, how postgres deal with it?
List	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?

From: Adrian Klaver
Date: 21 November 2012, 00:03:47
Subject: Re: get column name passed to a function

From: Gary Chambers
Date: 21 November 2012, 00:53:49
Subject: Re: timezone, how postgres deal with it?