TIMEFROMPARTS returns a time value based on specified time parts.
Time parts include hour, minute, seconds, fractions, and precisions arguments.
The example returns a time value from the specified timeparts.
SELECT TIMEFROMPARTS(11, 54, 08, 0, 0) AS Time
| Time |
|---|
| 11:54:08 |
Syntax of the TIMEFROMPARTS function .
TIMEFROMPARTS(hour, minute, seconds, fractions, precision)
hour -- an integer specifying hour.
minute -- an integer specifying minute.
seconds -- an integer specifying seconds.
fractions -- an integer specifying fractions.
precision -- an integer specifying precision of the returned time value.
Note: TIMEFROMPARTS will return an error if any of the arguments is invalid.
If any of the arguments is null, then the return value will also be null.
