Re: roundoff problem in time datatype

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