[logiclion]

but when should 23:59:59.9999999 switch to 00:00:00?

[hetman]

Easy, 00:00:00 is one second after 23:59:59. You can use 24:00:00 in some circumstances to refer to the midnigt at the end of a day but it would be redundant say on a clock face.