SQL Server DATETIMEFROMPARTS() Function

The SQL Server (Transact-SQL) DATETIMEFROMPARTS() function returns a datetime value from the specified date and time arguments.

The DATETIMEFROMPARTS() function returns NULL if any of the argument has a null value. For invalid arguments, an error will be raised.

Syntax

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

Parameters

`year`	`Required.` Specify the year of the datetime value.
`month`	`Required.` Specify the month of the datetime value.
`day`	`Required.` Specify the day of the datetime value.
`hour`	`Required.` Specify the hours of the datetime value.
`minute`	`Required.` Specify the minutes of the datetime value.
`seconds`	`Required.` Specify the seconds of the datetime value.
`milliseconds`	`Required.` Specify the milliseconds of the datetime value.

Return Value

Returns the datetime value from the specified parts.

Example 1:

The example below shows the usage of DATETIMEFROMPARTS() function.

SELECT DATETIMEFROMPARTS(1999, 10, 25, 22, 45, 58, 0);
Result: '1999-10-25 22:45:58.000'

SELECT DATETIMEFROMPARTS(1999, 10, 25, 22, 45, 58, 500);
Result: '1999-10-25 22:45:58.500'

Example 2:

Consider a database table called DateTimeTable with the following records:

ID	Year	Month	Day	Hours	Minutes	Seconds
1	1999	3	23	22	45	55
2	2003	6	8	5	34	21
3	2010	11	28	14	23	10
4	2004	8	14	9	8	19
5	2012	1	18	8	11	18

The following statement can be used to get the datetime value using the records of various columns of this table.

SELECT *, DATETIMEFROMPARTS(Year, Month, Day, Hours, Minutes, Seconds, 0) 
AS DATETIMEFROMPARTS_Value FROM DateTimeTable;

This will produce the result as shown below:

ID	Year	Month	Day	Hours	Minutes	Seconds	DATETIMEFROMPARTS_Value
1	1999	3	23	22	45	55	1999-03-23 22:45:55.000
2	2003	6	8	5	34	21	2003-06-08 05:34:21.000
3	2010	11	28	14	23	10	2010-11-28 14:23:10.000
4	2004	8	14	9	8	19	2004-08-14 09:08:19.000
5	2012	1	18	8	11	18	2012-01-18 08:11:18.000

❮ SQL Server Functions