Re: roundoff problem in time datatype

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: roundoff problem in time datatype
Дата
Msg-id dh96o9$oiq$1@news.hub.org
обсуждение исходный текст
Ответ на Re: roundoff problem in time datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 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'.

mmm. The second "60" have is on duration of 1 second so 23:59:60.4 have
is right to exist.


Regards
Gaetano Mendola



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: roundoff problem in time datatype
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Vacuum questions...