Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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

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