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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Дата
Msg-id CAKFQuwZhZqTHCSm7GEXiX4p2s96tBJV_+=X7E0ZoyPywNrZyBg@mail.gmail.com
обсуждение исходный текст
Ответ на Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))  (Robert Burgholzer <rburghol@vt.edu>)
Список pgsql-admin
Дерево обсуждения
On Tue, May 12, 2015 at 10:33 AM, Robert Burgholzer <rburghol@vt.edu> wrote:
Thoughts on this?  To me, it would seem intuitive that if you did not specify a timezone, the db would choose it's own local timestamp as the timezone.


​The timezone info is truncated.​

​From the documentation:​

​"​
In a literal that has been determined to be timestamp without time zone, PostgreSQL will silently ignore any time zone indication. That is, the resulting value is derived from the date/time fields in the input value, and is not adjusted for time zone.​
​"​


8.5.1.3 Time Stamps

Especially after the examples.

David J.


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

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