In article <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> writes:
> Harald Fuchs <[EMAIL PROTECTED]> writes: >> Bruce Momjian <pgman@candle.pha.pa.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 ;-) Well, Richard T. Snodgrass says in "Developing Time-Oriented Database Applications in SQL" (pg. 81) the following: > Most days have 24 hours. The day in April that daylight saving time > kicks in has only 23 hours; the day in October that daylight saving > time ends contains 25 hours. Similarly, minutes can have 62 seconds > (though up to 1999 only one leap second has ever been added to any > particular minute), as mentioned in this standard [44, p. 25]. where ref [44] is > ISO, Database Language SQL. ISO/IEC 9075: 1992. ANSI X3.135-1992 To me this sounds like 23:59:60, doesn't it? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend