As a database programmer sometime you may get values of day, month and year in integer format. You may need to use these values to generate a date in date datatype. For this purpose you can use the built-in function DATEFROMPARTS. This function was introduced in SQL Server 2012. This function accepts day, month and year values in integer and returns a date. Let’s see how to use DATEFROMPARTS.
Syntax
DATEFROMPARTS ( <year>, <month>, <day> ) Where: <year> = Years in integer, <month> = Months in integer, <day> = Days in integer
Example
DECLARE @year INT; DECLARE @month INT; DECLARE @day INT; SET @year = 2016 SET @month = 7 SET @day = 25 SELECT DATEFROMPARTS(@year, @month, @day); GO /* Result */ 2016-07-25

Reference
- About DATEFROMPARTS at Microsoft Docs.