SQL DATENAME()
The DATENAME() function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.
Home »
sql date function
SQL DATEFROMPARTS
SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.
SQL DATEADD()
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.