Laurenz Albe <[email protected]> writes:
> I dug into the git history, and it has been like that since commit
> b3506006b564
> in 2002 (way before version 9.x). That commit fixed a bug that returned ten
> time the correct reault (but still offset from the UTC epoch).
I didn't bisect, but I get this in 9.1.24:
regression=# set timezone = 'America/Los_Angeles';
SET
regression=# select to_timestamp(extract(epoch from current_date));
to_timestamp
------------------------
2025-11-21 00:00:00-08
(1 row)
and this in 9.2.24:
regression=# set timezone = 'America/Los_Angeles';
SET
regression=# select to_timestamp(extract(epoch from current_date));
to_timestamp
------------------------
2025-11-20 16:00:00-08
(1 row)
regards, tom lane
