Horton

Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dana Burd <djburd@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2021-01-01T20:54:20Z
Lists: pgsql-bugs 
Dana Burd <djburd@gmail.com> writes:
> On Fri, Jan 1, 2021 at 12:18 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Perhaps a better phrasing is "for date and timestamp values, the nominal
>> number of seconds since 1970-01-01 00:00:00, without regard to timezone
>> or daylight-savings rules".

> That phrasing makes sense.

Sounds good, done here:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4d3f03f42227bb351c2021a9ccea2fff9c023cfc

Also see

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=319f4d54e82d15d4a0c3f4cc1328c40dba024b5c

			regards, tom lane

Commits

  1. Doc: improve explanation of EXTRACT(EPOCH) for timestamp without tz.

  2. Doc: spell out comparison behaviors for the date/time types.