Christoph Berg <c...@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