Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Ribe
Subject Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Date
Msg-id 18E25F6F-7209-43A3-BEAB-8A85D2A47461@elevated-dev.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
Tree view 
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 by date:

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