MySQL in a Nutshell

Name

MAKETIME( )

Synopsis

MAKETIME(hour, minute, second)

This function converts a given hour, minute, and second to hh:mm:ss format. It returns NULL if the value for minute is greater than 60 or if second is greater than 59. It will accept an hour greater than 24. This function is available as of Version 4.1.1 of MySQL.

SELECT MAKETIME(14, 32, 5)
   AS Time;
+----------+
| Time     |
+----------+
| 14:32:05 |
+----------+