Re: timezones BCE

[chap]

On 2022-04-13 12:33, Dave Cramer wrote:

test=# set timezone to 'America/Toronto';
SET
test=# select '0101-01-01'::timestamptz;
         timestamptz
------------------------------
 0101-01-01 00:00:00-05:17:32

Specifically why the -05:17:32

Timezones were regularized into their (typically hour-wide) chunks
during a period around the late nineteenth century IIRC.

If you decompile the zoneinfo database to look at America/Toronto,
you will probably find an entry for dates earlier than when the
regularized zones were established there, and that entry will have
an offset reflecting Toronto's actual longitude.

Regards,
-Chap