Re: BUG #1927: incorrect timestamp returned - Mailing list pgsql-bugs

From Kouber Saparev
Subject Re: BUG #1927: incorrect timestamp returned
Date
Msg-id 43417855.1090604@saparev.com
Whole thread Raw
In response to Re: BUG #1927: incorrect timestamp returned  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: BUG #1927: incorrect timestamp returned
List pgsql-bugs
>>
>>select timestamp '2005-09-23 23:59:59.9999999'
>>
>>I get the following result (note the value of the seconds):
>>
>>2005-09-23 23:59:60.00
>
>
> It's the leap second.
>
>

It is not a leap second. Leap seconds are always either on the 30th of
June or on the 31th of December.

Here there is a list of all the leap seconds so far:
http://en.wikipedia.org/wiki/Leap_second

And, in fact, the wrong result is the same for each date, regardless of
the year, month or day.

--
Kouber Saparev
http://kouber.saparev.com/

pgsql-bugs by date:

Previous
From: "Alon Goldshuv"
Date:
Subject: BUG #1936: Read-only transactions ignored in COPY
Next
From: "Jean-Pierre Pelletier"
Date:
Subject: Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2