In article <[EMAIL PROTECTED]>,
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> Tony Caduto wrote:
>> Hi,
>> I just noticed today that Postgresql accepts a value of 24:00:00, this 
>> is for sure not correct as there is no such thing as 24:00:00
>> 
>> PG Admin III will display this value just fine which is also incorrect,  
>> PG Lightning Admin catches it as a invalid time, but shouldn't there be 
>> some validation of times and dates at the server level?  
>> 
>> There are people who are using PG Admin III and they don't even know 
>> they have bogus dates and times in their databases.

> 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'?


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to