Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Date
Msg-id CAKFQuwZhZqTHCSm7GEXiX4p2s96tBJV_+=X7E0ZoyPywNrZyBg@mail.gmail.com
Whole thread Raw
In response to Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))  (Robert Burgholzer <rburghol@vt.edu>)
List 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 by date:

Previous
From: Robert Burgholzer
Date:
Subject: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Next
From: Scott Ribe
Date:
Subject: Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))