MAKE_TIME

​

Syntax

​

Scalar

make_time(hour, minute, second)

​

Arguments

​

Returns

• Type: TIME with microsecond precision
• NULL behavior: Any NULL component yields NULL. Non-finite seconds and out-of-range components raise an error.

​

Properties

​

Usage notes

• Fractional seconds round to the nearest microsecond.
• Hour/minute are converted to INTEGER; second retains a DOUBLE fractional component.
• A sub-60 second value rounding to 60 seconds is clamped to 59.999999 seconds.
• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.

​

Examples

​

Basic example

SELECT make_time(10,30,45.5) AS result;

​

Midnight and fractional seconds

SELECT make_time(0, 0, 0) AS midnight, make_time(23, 59, 59.25) AS late_time;