TIME_FORMAT(time,format): The format string may contain format specifiers only for hours, minutes, and seconds : TIME_FORMAT « Date Time Functions « MySQL Tutorial






mysql>
mysql> SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l');
+--------------------------------------------+
| TIME_FORMAT('100:00:00', '%H %k %h %I %l') |
+--------------------------------------------+
| 100 100 04 04 4                            |
+--------------------------------------------+
1 row in set (0.00 sec)

mysql>








14.48.TIME_FORMAT
14.48.1.TIME_FORMAT(time,format)
14.48.2.TIME_FORMAT(time,format): The format string may contain format specifiers only for hours, minutes, and seconds