Re: roundoff problem in time datatype - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: roundoff problem in time datatype
Date
Msg-id dh96o9$oiq$1@news.hub.org
Whole thread Raw
In response to Re: roundoff problem in time datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: roundoff problem in time datatype
Next
From: Alvaro Herrera
Date:
Subject: Re: Vacuum questions...