Search Postgresql Archives

Re: time value '24:00:00'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday 02 November 2006 00:16, Richard Huxton wrote:
> 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

Yeah, but isn't the third part milliseconds? Doesn't "milli" imply 1000 and 
not 60. I may be totally off here though - well, it's getting late

	UC

--
Open Source Solutions 4U, LLC	1618 Kelly St
Phone:  +1 707 568 3056		Santa Rosa, CA 95401
Cell:   +1 650 302 2405		United States
Fax:    +1 707 568 6416


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux