Example
Return a date from its parts:
SELECT DATEFROMPARTS(2018, 10, 31) AS DateFromParts;
Definition and Usage
The DATEFROMPARTS() function returns a date from the specified parts (year, month, and day values).
Syntax
DATEFROMPARTS(year, month, day)