Re: time value '24:00:00' - Mailing list pgsql-general

From Richard Huxton
Subject Re: time value '24:00:00'
Date
Msg-id 4549A95D.1010800@archonet.com
Whole thread Raw
In response to Re: time value '24:00:00'  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Responses Re: time value '24:00:00'
List pgsql-general
Uwe C. Schroeder wrote:
> why don't you just use < '00:00:00'::time
> and avoid the issue?
>
> IMHO there shouldn't even be a 24:00:00, because that would imply that there
> is a 24:00:01 - which there is not.
> It should go from 23:59 to 00:00
> But then, I didn't write the spec for time in general, so maybe there is a
> 24:00 which is identical to 00:00

Ah, times and dates are wonderful things though. For example, '23:59:60'
is a valid time (and not equal to 24:00:00 or 00:00:00) every so often.

http://en.wikipedia.org/wiki/Leap_second

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: Updated: Compiling/Installing as a non-admin user
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: time value '24:00:00'