Home > mailing lists

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

From	Anibal David Acosta
Subject	timezone, how postgres deal with it?
Date	November 22, 2012 18:37:07
Msg-id	004701cdc8c7$3a5cf4b0$af16de10$@devshock.com Whole thread Raw
Responses	Re: timezone, how postgres deal with it? (Tom Lane <tgl@sss.pgh.pa.us>) Re: timezone, how postgres deal with it? ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List	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

From: Shamim Uddin
Date: 22 November 2012, 15:17:33
Subject: FW: [webmaster] Information Required

From: Tom Lane
Date: 22 November 2012, 18:55:04
Subject: Re: timezone, how postgres deal with it?