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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dana Burd <djburd(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone
Date: 2021-01-01 20:54:20
Message-ID: 2536619.1609534460@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dana Burd <djburd(at)gmail(dot)com> writes:
> On Fri, Jan 1, 2021 at 12:18 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-01-02 15:00:00 BUG #16801: Invalid memory access on WITH RECURSIVE with nested WITHs
Previous Message Dana Burd 2021-01-01 19:14:20 Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone