MySQL Tutorial/Date Time Functions/MAKETIME

MAKETIME(hour,minute,second) returns a time value calculated from the hour, minute, and second arguments.

   <source lang="sql">

mysql> mysql> mysql> SELECT MAKETIME(12,15,30); +--------------------+ | MAKETIME(12,15,30) | +--------------------+ | 12:15:30 | +--------------------+ 1 row in set (0.00 sec) mysql></source>