MAKETIME

Formulate and return a time value using specified hour, minute, and second components.

SELECT MAKETIME(11, 35, 4);

Definition and Usage

The MAKETIME() function constructs and returns a time using specified hour, minute, and second values.

MAKETIME(hour, minute, second)

Parameter	Description
hour	Mandatory: The value representing hours
minute	Mandatory: The value representing minutes
second	Mandatory: The value representing seconds

Works in:

From MySQL version 4.0

Generate and provide a time value using specified hour, minute, and second components.

SELECT MAKETIME(16, 1, 0);

Construct and return a time value using specified hour, minute, and second components.

SELECT MAKETIME(21, 59, 59);

Formulate and return a time value using specified hour, minute, and second components.

SELECT MAKETIME(838, 59, 59);