Postgres Pro
Downloads
Home   >   mailing lists

timezones BCE - Mailing list pgsql-hackers

From Dave Cramer
Subject timezones BCE
Date
Msg-id CADK3HHK45Obsn3XLVynJkJ-=vvyuO1JRRg-SadWXLt0dXqz+vg@mail.gmail.com
Whole thread Raw
Responses Re: timezones BCE  (chap@anastigmatix.net)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: row filtering for logical replication
Next
From: Peter Geoghegan
Date:
Subject: Re: Improving the "Routine Vacuuming" docs