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 SERVER » SQL Functions »
Date Functions
SQL Date functions are used to manipulate with date strings.
SQL DATEFROMPARTS
SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.
SQL DATEPART()
SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.
SQL DATEADD()
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.
SQL EOMONTH()
SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.