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, and seconds. Other
specifiers produce a NULL value or 0.

URL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

