Re: BUG #1927: incorrect timestamp returned

Поиск
Список
Период
Сортировка
От Kouber Saparev
Тема Re: BUG #1927: incorrect timestamp returned
Дата
Msg-id 43417855.1090604@saparev.com
обсуждение исходный текст
Ответ на Re: BUG #1927: incorrect timestamp returned  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: BUG #1927: incorrect timestamp returned  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Alon Goldshuv"
Дата:
Сообщение: BUG #1936: Read-only transactions ignored in COPY
Следующее
От: "Jean-Pierre Pelletier"
Дата:
Сообщение: Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2