timezones BCE

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: timezones BCE
Date: 2022-04-13 16:33:01
Message-ID: CADK3HHK45Obsn3XLVynJkJ-=vvyuO1JRRg-SadWXLt0dXqz+vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2022-04-13 16:34:22 Re: Improving the "Routine Vacuuming" docs
Previous Message Alvaro Herrera 2022-04-13 16:31:33 Re: row filtering for logical replication