Timestamp with timezone output

From: Arnaud Inovia Team <arnaud(dot)becher(at)inovia-team(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamp with timezone output
Date: 2016-05-25 14:47:59
Message-ID: CAEOq=Atxuh7Mi2sJTHXsr_bBxT=z6tLecbWua1Dk725q3oxZWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
<https://www.facebook.com/pages/Inovia-Team/147815591928404>
<https://twitter.com/inoviateam>
<https://www.linkedin.com/company/1099225?trk=tyah&trkInfo=tarId%3A1414773408012%2Ctas%3Ainovia%2Cidx%3A2-3-6>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2016-05-25 14:57:18 Re: Timestamp with timezone output
Previous Message Umair Shahid 2016-05-25 06:57:13 Re: Members in the Middle East?