Make_time

sql

FUNCTION Make_time(IN hours INT, IN minutes INT, IN seconds INT, IN sec1000 INT) RETURNS TIME;

Parameters

hours hours count
minutes minutes count
seconds seconds count
sec1000 thousandths of seconds count

Description

The Make_time function creates a time from the 4 components: hours, minutes, seconds and thousandths of seconds. The allowed ranges are - 0 to 23 for hours, 0 to 59 for minutes and seconds, 0 to 999 for thousandths of seconds.

Function value

This function returns the created time in the 602SQL internal format. If the specified time cannot be created (e.g. 25:00), the function will return NULL.

See