Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

On Thu, 21 Aug 2003, Arnold Mavromatis wrote:

> Hi Stephan and everyone

Hmm, I just got my machine to give a similar failure mode with
a slightly wacky input.

sszabo=> select timestamptz '1901/12/13 23:59:59.99999';
        timestamptz
---------------------------
 1901-12-13 23:59:59.99999
(1 row)

sszabo=> select timestamptz '1901/12/13 23:59:59.999999999';
      timestamptz
------------------------
 1901-12-13 16:00:00-08
(1 row)

sszabo=> select timestamptz '1901/12/14 0:0:0';
      timestamptz
------------------------
 1901-12-14 00:00:00-08
(1 row)

This happens on both 7.3.4 and 7.4.