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 4272FB86-B759-42FD-8DAF-1B4C5D1E218A@elevated-dev.com
Whole thread Raw
In response to Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))  (Robert Burgholzer <rburghol@vt.edu>)
Responses 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 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 by date:

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