# 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
``````