Postgres Pro
Downloads
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
Msg-id 011e01cdc768$c4fd1920$4ef74b60$@devshock.com
Whole thread Raw
Responses Re: timezone, how postgres deal with it?  (Gary Chambers <gwchamb@gwcmail.com>)
Re: timezone, how postgres deal with it?  (Adrian Klaver <adrian.klaver@gmail.com>)
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)

 

Why?

 

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

 

 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: get column name passed to a function
Next
From: Gary Chambers
Date:
Subject: Re: timezone, how postgres deal with it?