Description: Returns a time in a format specified by format. Formatting options are the same as for DATE_FORMAT() and are as shown previously in Table C.2.
TIME_FORMAT() can handle only format specifiers for hours, minutes, and seconds, or NULL or 0 will be returned.
Examples:
TIME_FORMAT('2002-01-05 16:20:00','%r') returns 04:20:00 PM.
TIME_FORMAT('16:20:00','At %r') returns At 04:20:00 PM.
See also: DATE_FORMAT()
3.129.24.180