TIME_FORMAT

Syntax

TIME_FORMAT(time,format)

Purpose

The TIME_FORMAT function is similar to the DATE_FORMAT function, but the format parameter only supports format specifiers for hours, minutes, seconds, and microseconds.

If the time value contains an hour part greater than 23, the %H and %k hour format specifiers generate values greater than 0..23, while other hour format specifiers generate hour values (mod 12).

Examples

obclient> 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