Re: Question about Postgresql time fields(possible bug)

On 10/1/06 18:00, "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com> wrote:

> Dave Page wrote:
>
>>
>> On looking further it appears to me that 24:00:00 is not a leap second
>> (which definitely can be 23:50:60), but just another way of expressing
>> midnight.
>>
>> From: http://www.cl.cam.ac.uk/~mgk25/iso-time.html
>>
>>
>>
> Hi Dave,
> That may be true, but I don't think 24:00:00 is the standard way of
> doing it, have you ever seen your PC clock roll over to 24:00:00
>
> For a PC/server based bios clock 24:00:00 is not a valid time, a lot of
> programming languages datetime routines will not accept a time of 24:00:00.

Hi Tony,

That's not really the point. The ISO 8601 standard allows midnight to be
expressed as 00:00:00 or 24:00:00 to enable you to tell which midnight is
being referred to (ie. The beginning or the end of the day).

PostgreSQL allows you to make use of that part of the standard, and as admin
tool authors I think we should honour what it allows, provided it's not
blatantly non-standard. It's up to the user to decide whether or not they
actually make use of the facility.

Just my tuppence worth :-)

Regards, Dave.