Re: Question about Postgresql time fields(possible bug)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harald Fuchs <hf0923x(at)protecting(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question about Postgresql time fields(possible bug)
Date: 2006-01-10 17:14:58
Message-ID: 1292.1136913298@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Harald Fuchs <hf0923x(at)protecting(dot)net> writes:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> A leap second will show as 24:00:00. It is a valid time.

> Shouldn't such a leap second be represented as '... 23:59:60'?

People who didn't like 24:00:00 would complain about that, too ;-)

Actually, my recollection is that we decided to allow 24:00:00 for
reasons unrelated to leap seconds. See the archives --- this was
debated and agreed to not all that long ago. PG 8.0 and before
don't allow it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-01-10 17:15:04 Re: Question about Postgresql time fields(possible bug)
Previous Message Harald Fuchs 2006-01-10 16:52:54 Re: Question about Postgresql time fields(possible bug)