DATETIME2FROMPARTS (TSQL Function)
Returns a datetime created from the specified parts.
Syntax
DATETIME2FROMPARTS ( year , month , day , hour , minute , seconds , fractions, precision )
Arguments
- year
- is an expression of type
int. - month
- is an expression of type
int. - day
- is an expression of type
int. - 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 datetime.
Examples
PRINT DATETIME2FROMPARTS (2016, 5, 15, 13, 30, 15, 0, 0);
PRINT DATETIME2FROMPARTS (2016, 5, 15, 13, 30, 15, 123, 3);
PRINT DATETIME2FROMPARTS (2016, 5, 15, 13, 30, 15, 123456, 6);
PRINT DATETIME2FROMPARTS (2016, 5, 15, 13, 30, 15, 123456789, 9);
The result is:
2016-05-15 13:30:15
2016-05-15 13:30:15.123000000
2016-05-15 13:30:15.123456000
2016-05-15 13:30:15.123456789