<code>select DATE_FORMAT('2099-01-12T23:59:59.999999999:00', '%H:%i:%s');
</code>
<code>select DATE_FORMAT('2099-01-12T23:59:59.999999999:00', '%H:%i:%s');
</code>
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