tzdata 2025a and timestamptz.out
Started by Christoph Berg12 months ago2 messages
It happened again:
News for the tz database
Release 2025a - 2025-01-15 10:47:24 -0800
Briefly:
...
Improve pre-1991 data for the Philippines.
SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC';
timezone
--------------------------
- Wed Dec 09 15:56:00 1846
+ Wed Dec 09 15:56:08 1846Christoph
Re: tzdata 2025a and timestamptz.out
Christoph Berg <cb@df7cb.de> writes:
SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; timezone -------------------------- - Wed Dec 09 15:56:00 1846 + Wed Dec 09 15:56:08 1846
Grumble. Let's switch to using Asia/Singapore in this test case.
It has a roughly similar UTC offset, and that offset hasn't
changed in tzdb since 2003. (Gotta love "git blame".)
regards, tom lane