Re: time value '24:00:00'

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: time value '24:00:00'
Date: 2006-11-02 09:06:40
Message-ID: 200611020106.40422.uwe@oss4u.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 02 November 2006 00:59, Richard Huxton wrote:
> Uwe C. Schroeder wrote:
> >> 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
>
> Nope - hh:mm:ss.milli
> And it's early in London, so it *must* be late in Western U.S.A. - see
> you later :-)

You're right of course. Seconds! Who would have thought about that :-)
It's past 1am, so I guess I should go hit the mattress ...

PS: and I heard it's darn cold over there too ....

Uwe

--
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2006-11-02 09:09:02 Re: postgres import
Previous Message Richard Huxton 2006-11-02 08:59:55 Re: time value '24:00:00'