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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
