Re: Timestamp with timezone output

Поиск
Список
Период
Сортировка
Искать
От
Larry Rosenman
Тема
Re: Timestamp with timezone output
Дата
в 14:57:25
Msg-id
089ebf89f6c1101dc4e15d8cd952dc96@thebighonker.lerctr.org
Ответ на
Timestamp with timezone output (Arnaud Inovia Team)
Список
Дерево обсуждения
Timestamp with timezone output Arnaud Inovia Team <arnaud.becher@inovia-team.com>
Re: Timestamp with timezone output Larry Rosenman <ler@lerctr.org>
Re: Timestamp with timezone output Kevin Grittner <kgrittn@gmail.com>
Re: Timestamp with timezone output Arnaud Inovia Team <arnaud.becher@inovia-team.com>
Re: Timestamp with timezone output Guillaume Lelarge <guillaume@lelarge.info>

On 2016-05-25 09:47, Arnaud Inovia Team wrote:

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 !

 

Daylight Savings Time?

 

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640                 E-Mail: ler@lerctr.org
US Mail: 17716 Limpia Crk, Round Rock, TX 78664-7281
В списке pgsql-general по дате отправления
Предыдущее
От: Arnaud Inovia Team
Дата:
Сообщение: Timestamp with timezone output
Следующее
От: Guillaume Lelarge
Дата:
FAQ