   TIME_FORMAT(time,format)
This is used like the DATE_FORMAT() function, but the
format string may contain only those format specifiers that handle
hours, minutes, and seconds.  Other specifiers produce a NULL value or
0.
