Re: tzdata 2025a and timestamptz.out

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph Berg <cb(at)df7cb(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: tzdata 2025a and timestamptz.out
Date: 2025-01-20 20:09:00
Message-ID: 3081498.1737403740@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christoph Berg <cb(at)df7cb(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2025-01-20 20:15:43 Re: Re: proposal: schema variables
Previous Message Jim Jones 2025-01-20 19:56:28 Re: XMLDocument (SQL/XML X030)