Re: timezones BCE

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