Timestamp with timezone output

Поиск

Список

Период

Сортировка

От	Arnaud Inovia Team
Тема	Timestamp with timezone output
Дата	25 мая 2016 г. 17:48:25
Msg-id	CAEOq=Atxuh7Mi2sJTHXsr_bBxT=z6tLecbWua1Dk725q3oxZWg@mail.gmail.com обсуждение исходный текст
Ответы	Re: Timestamp with timezone output (Larry Rosenman <ler@lerctr.org>) Re: Timestamp with timezone output (Guillaume Lelarge <guillaume@lelarge.info>) Re: Timestamp with timezone output (Kevin Grittner <kgrittn@gmail.com>)
Список	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