Re: time value '24:00:00'

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:59:55
Message-ID: 4549B38B.3090503@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2006-11-02 09:06:40 Re: time value '24:00:00'
Previous Message Hari Bhaskaran 2006-11-02 08:57:08 Availability of pg_backend_pid() immediately after connection establishment