Postgres Pro
Downloads
Home   >   mailing lists

Timestamp with timezone output - Mailing list pgsql-general

From Arnaud Inovia Team
Subject Timestamp with timezone output
Date
Msg-id CAEOq=Atxuh7Mi2sJTHXsr_bBxT=z6tLecbWua1Dk725q3oxZWg@mail.gmail.com
Whole thread Raw
Responses Re: Timestamp with timezone output
Re: Timestamp with timezone output
Re: Timestamp with timezone output
List pgsql-general
Tree view
I have some question regarding some timezone behaviour.

Documentation is saying:

> When a timestamp with time zone value is output, it is always converted from UTC to the current timezone zone, and displayed as local time in that zone. To see the time in another time zone, either change timezone or use the AT TIME ZONE construct (see Section 9.9.3).

While using "psql", when selecting a column timestamp with timezone, I get results with different timezones:

-[ RECORD 6 ]---+-----------------------
expiration_date | 2015-09-07 00:00:00+02
-[ RECORD 7 ]---+-----------------------
expiration_date | 2015-11-27 00:00:00+01

Shouldn't all value be converted to the same timezone ?

Thank you for your help !

--
Arnaud Becher
Paris - San Francisco
10 rue du Faubourg Poissonnière - 75010 Paris
T. + 33 (0)6 17 15 52 43
http://www.inovia.fr
  
Attachment

pgsql-general by date:

Previous
From: Umair Shahid
Date:
Subject: Re: Members in the Middle East?
Next
From: Larry Rosenman
Date:
Subject: Re: Timestamp with timezone output