MAKE_TIME

This function returns a time value for the specified hour, minute, and second.

Syntax

MAKE_TIME ( hour, minute, second ) 

Arguments

hour
An numeric expression that specifies the hour.

minute
An numeric expression that specifies the minute.

second
An numeric expression that specifies the second.

Return Value

Returns the new time as a TIME data type.

Remarks

• The hour, minute, and second values may be outside their usual ranges and will be normalized during the conversion.

Examples

This example makes a time value using numeric values.

SELECT MAKE_TIME(24, 3, -2);

Response:

MAKE_TIME(24, 3, -2) [TIME]
00:02:58