sql server date functions

SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.