From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: roundoff problem in time datatype |
Date: | 2005-09-26 16:13:58 |
Message-ID: | dh96o9$oiq$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Dennis Bjorklund <db(at)zigo(dot)dhs(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-09-26 16:15:45 | Re: Vacuum questions... |
Previous Message | Bruce Momjian | 2005-09-26 15:53:56 | Re: [HACKERS] statement logging / extended query protocol issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Bjorklund | 2005-09-26 16:22:17 | Re: roundoff problem in time datatype |
Previous Message | Bruce Momjian | 2005-09-26 15:53:56 | Re: [HACKERS] statement logging / extended query protocol issues |