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