select DATE_FORMAT('2099-01-12T23:59:59.999999999:00', '%H:%i:%s');
Result: 00:00:00
Why? I want 23:59:59
How to do that?
0
select DATE_FORMAT('2099-01-12T23:59:59.999999999:00', '%H:%i:%s');
Result: 00:00:00
Why? I want 23:59:59
How to do that?
0