In article <1292.1136913298@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Harald Fuchs <hf0923x@protecting.net> 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?