| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, "pgsql-general(at)list(dot)coretech(dot)ro" <pgsql-general(at)list(dot)coretech(dot)ro> |
| Subject: | Re: time value '24:00:00' |
| Date: | 2006-11-02 08:16:29 |
| Message-ID: | 4549A95D.1010800@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Uwe C. Schroeder | 2006-11-02 08:54:38 | Re: time value '24:00:00' |
| Previous Message | Shoaib Mir | 2006-11-02 07:42:43 | Re: Updated: Compiling/Installing as a non-admin user |