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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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