Can someone help me understand
select '0101-01-01'::timestamptz;
timestamptz
------------------------
0101-01-01 00:00:00+00
(1 row)
test=# set timezone to 'America/Toronto';
SET
test=# select '0101-01-01'::timestamptz;
timestamptz
------------------------------
0101-01-01 00:00:00-05:17:32
(1 row)
select 'now()'::timestamptz;
timestamptz
-------------------------------
2022-04-13 12:31:57.271967-04
(1 row)
Specifically why the -05:17:32
Dave Cramer