TIMEFROMPARTS
Returns a time value for the specified time and with the specified precision.
Syntax
TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )
Arguments
hour
Integer expression specifying hours.
minute
Integer expression specifying minutes.
seconds
Integer expression specifying seconds.
fractions
Integer expression specifying fractions.
precision
Integer literal specifying the precision of the time value to be returned.
Return types
time( precision )
Example
SELECT TIMEFROMPARTS(14,23,44,500,3);