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

From Richard Huxton
Subject Re: time value '24:00:00'
Date
Msg-id 4549BA9D.5080008@archonet.com
Whole thread Raw
In response to Re: time value '24:00:00'  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List pgsql-general
Uwe C. Schroeder wrote:
> 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 ....

Winter has finally arrived in the U.K. - I hear it was -6C in Wales
first thing this morning.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: postgres import
Next
From: "Magnus Hagander"
Date:
Subject: Re: Availability of pg_backend_pid() immediately after connection establishment