Re: roundoff problem in time datatype

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: roundoff problem in time datatype
Дата
Msg-id 24340.1127744911@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: roundoff problem in time datatype  (Dennis Bjorklund <db@zigo.dhs.org>)
Ответы Re: roundoff problem in time datatype  (Dennis Bjorklund <db@zigo.dhs.org>)
Re: roundoff problem in time datatype  (Greg Stark <gsstark@mit.edu>)
Re: roundoff problem in time datatype  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-hackers
Dennis Bjorklund <db@zigo.dhs.org> writes:
> On Mon, 26 Sep 2005, Tom Lane wrote:
>> No, I think the usual notation for a leap-second is '23:59:60'.
>> We do allow 60 in the seconds field for this purpose.

> Yes, and it can go up to 23:59:60.999999 (depending on how many fractional 
> seconds one want).

That's an urban legend.  There never have been, and never will be, two
leap seconds instituted in the same minute.  We really should reject
anything larger than '23:59:60'.

> One "solution" is to round '23:59:59.9'::time(0) up to '00:00:00'.

7.2 did that, and we concluded it was broken.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: roundoff problem in time datatype
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: roundoff problem in time datatype