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 4272FB86-B759-42FD-8DAF-1B4C5D1E218A@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))  (Robert Burgholzer <rburghol@vt.edu>)
Ответы Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Список pgsql-admin
Дерево обсуждения 
On May 12, 2015, at 12:07 PM, Robert Burgholzer <rburghol@vt.edu> wrote:
>
> But if nothing else, it still seems to me that "to_timestamp" and "extract(epoch)" are making different assumptions
whenTZ is not known. 

Not really, it’s just that by default the result of to_timestamp is *displayed* in your local zone.

--
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
Дата:
Сообщение: Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Следующее
От: Robert Burgholzer
Дата:
Сообщение: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))