Skip site navigation (1) Skip section navigation (2)

Re: roundoff problem in time datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: roundoff problem in time datatype
Date: 2005-09-26 14:28:31
Message-ID: 24340.1127744911@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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'.

> 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

In response to

Responses

pgsql-hackers by date

Next:From: Dennis BjorklundDate: 2005-09-26 14:40:03
Subject: Re: roundoff problem in time datatype
Previous:From: Dennis BjorklundDate: 2005-09-26 14:16:09
Subject: Re: roundoff problem in time datatype

pgsql-patches by date

Next:From: Dennis BjorklundDate: 2005-09-26 14:40:03
Subject: Re: roundoff problem in time datatype
Previous:From: Dennis BjorklundDate: 2005-09-26 14:16:09
Subject: Re: roundoff problem in time datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group