top of page
© 2025 by The Clinic. Powered and secured by Wix
MySQL:
TIME_FORMAT
Syntax:
TIME_FORMAT(time,format)
This is used like the DATE_FORMAT() function, but the format string may
contain format specifiers only for hours, minutes, seconds, and
microseconds. Other specifiers produce a NULL value or 0.
URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
Example
mysql> SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l');
-> '100 100 04 04 4'
bottom of page