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

Reply via email to