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

Re: roundoff problem in time datatype

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>,Dave Cramer <pg(at)fastcrypt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: roundoff problem in time datatype
Date: 2005-09-26 15:04:13
Message-ID: 87k6h3hnv6.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> 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'.

I don't understand. The last second of a normal minute goes from 59.0 to
59.999 (etc) before the next minute begins. So surely the last second of a
minute containing a leap second goes from 60.0 to 60.999?

-- 
greg


In response to

pgsql-hackers by date

Next:From: Dave PageDate: 2005-09-26 15:08:47
Subject: Re: Server process exited with unexpected status 128.
Previous:From: Tom LaneDate: 2005-09-26 15:01:17
Subject: Re: Server process exited with unexpected status 128.

pgsql-patches by date

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

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