DATETIMEFROMPARTS (TSQL Function)

Returns a datetime created from the specified parts.

Syntax

DATETIMEFROMPARTS ( year , month , day , hour , minute , seconds , milliseconds )

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.
milliseconds
is an expression of type int.

Return Types

Returns datetime.

Examples

PRINT DATETIMEFROMPARTS (2016, 5, 15, 13, 30, 15, 500);

The result is:

2016-05-15 13:30:15.500000000