TIMEFROMPARTS (TSQL Function)
Returns a time created from the specified parts.
Syntax
TIMEFROMPARTS ( hour , minute , seconds , fractions , precision )
Arguments
- hour
- is an expression of type
int
. - minute
- is an expression of type
int
. - seconds
- is an expression of type
int
. - fractions
- is the subsecond fractional part. It is of type
int
. Its precision is given by the precision argument. - precision
- precision of the fractions argument. It is of type
int
, in the range [0, 9].
E.g. 3 means that fractions is specified as milliseconds; 9 is for nanoseconds.
Return Types
Returns time
.
Examples
PRINT TIMEFROMPARTS(13, 30, 15, 0, 0);
The result is:
13:30:15
Example with fractions:
PRINT TIMEFROMPARTS(13, 30, 15, 5, 1); -- 5/10th of a second
PRINT TIMEFROMPARTS(13, 30, 15, 50, 2); -- 5/100th of a second
PRINT TIMEFROMPARTS(13, 30, 15, 500, 3); -- 5/1000th of a second
The result is:
13:30:15.500000000
13:30:15.500000000
13:30:15.500000000