MySQL Tutorial/Date Time Functions/MAKETIME

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

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