Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Дата
Msg-id 18E25F6F-7209-43A3-BEAB-8A85D2A47461@elevated-dev.com
обсуждение исходный текст
Ответ на Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))  (Robert Burgholzer <rburghol@vt.edu>)
Список pgsql-admin
Дерево обсуждения 
On May 12, 2015, at 5:49 PM, Robert Burgholzer <rburghol@vt.edu> wrote:
>
> to_timestamp translates into the local TZ Always.

No, it translates to UTC, but timestamps by default display in your local timezone. Look at your example, the result of
to_timestampis midnight UTC as expected, which in your time zone is 19:00. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

В списке pgsql-admin по дате отправления:

Предыдущее
От: Robert Burgholzer
Дата:
Сообщение: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))