MAKETIME(hour,minute,second)

Returns a time value calculated from the hour, minute, and second arguments. Returns NULL if any of its arguments are NULL.

Syntax

MYSQL Copy

SELECT MAKETIME(12,15,30);
'12:15:30'

Examples

Example

The second argument can have a fractional part.

MYSQL Copy

SELECT MAKETIME(12,15,30);
'12:15:30'