MySQL in a Nutshell, 2nd Edition

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 the minute or the second values are greater than 59. It will accept an hour value greater than 24, though. This function is available as of version 4.1.1 of MySQL. Here is an example:

SELECT MAKETIME(14, 32, 5)
AS Time;

+----------+
| Time     |
+----------+
| 14:32:05 |
+----------+