Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone
Date
Msg-id 2536619.1609534460@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone  (Dana Burd <djburd@gmail.com>)
List 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



pgsql-bugs by date:

Previous
From: Dana Burd
Date:
Subject: Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone
Next
From: PG Bug reporting form
Date:
Subject: BUG #16801: Invalid memory access on WITH RECURSIVE with nested WITHs