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

From Dave Cramer
Subject Re: roundoff problem in time datatype
Date
Msg-id 2017792B-EB5B-4275-B771-4AF35599976B@fastcrypt.com
Whole thread Raw
In response to Re: roundoff problem in time datatype  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: roundoff problem in time datatype
List pgsql-hackers
Actually, I think there is a case where 24:00 is a proper time. Isn't
it used for adding leap seconds ?

Dave
On 26-Sep-05, at 3:39 AM, Dennis Bjorklund wrote:

> On Sun, 25 Sep 2005, Tom Lane wrote:
>
>
>> Alternatively: why are we forbidding the value 24:00:00 anyway? Is
>> there a reason not to allow the hours field to exceed 23?
>>
>
> One reason is because it's what the standard demand. Another is
> that it
> isn't a proper time, just like feb 31 isn't a proper date.
>
> --
> /Dennis Björklund
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly
>
>



pgsql-hackers by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: "expected authentication request from server, but
Next
From: Tom Lane
Date:
Subject: Re: roundoff problem in time datatype