MySQL MAKETIME() Function

Create and return a time value based on an hour, minute, and second value:

SELECT MAKETIME(11, 35, 4);

Definition and Usage

The MAKETIME() function creates and returns a time based on an hour, minute, and second value.

MAKETIME( hour, minute, second)

Works in:	From MySQL 4.0

Create and return a time value based on an hour, minute, and second value:

SELECT MAKETIME(16, 1, 0);

Create and return a time value based on an hour, minute, and second value:

SELECT MAKETIME(21, 59, 59);

Create and return a time value based on an hour, minute, and second value:

SELECT MAKETIME(838, 59, 59);