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

From Tom Lane
Subject Re: roundoff problem in time datatype
Date
Msg-id 23746.1127740514@sss.pgh.pa.us
Whole thread Raw
In response to Re: roundoff problem in time datatype  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: roundoff problem in time datatype
List pgsql-hackers
Dave Cramer <pg@fastcrypt.com> writes:
> Actually, I think there is a case where 24:00 is a proper time. Isn't  
> it used for adding leap seconds ?

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.

I suppose there's another possible approach, which is to special-case
the output of this value to look like '23:59:60' instead of '24:00:00'.
Then it could be reloaded.  On the whole though, most people who came
across that behavior would probably think it's a bug...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: roundoff problem in time datatype
Next
From: Tom Lane
Date:
Subject: Re: "expected authentication request from server, but received..."