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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Robert Burgholzer <rburghol(at)vt(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Date: 2015-05-12 18:31:25
Message-ID: 4272FB86-B759-42FD-8DAF-1B4C5D1E218A@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On May 12, 2015, at 12:07 PM, Robert Burgholzer <rburghol(at)vt(dot)edu> wrote:
>
> But if nothing else, it still seems to me that "to_timestamp" and "extract(epoch)" are making different assumptions when TZ 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Burgholzer 2015-05-12 23:49:47 Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))
Previous Message Robert Burgholzer 2015-05-12 18:07:52 Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp))