Date functions for SQL

The date function is shown in the following table.
Description
The datename and DATEPART functions return the integer value of the string that corresponds to the specified date element in the date, respectively.

Function	Parameters	Function
GETDATE	()	Returns the current date and time of the system
DATEADD	(datepart,number,date)	Returns datetime or smalldatetime type data whose value is the date value plus the time interval specified by the DATEPART and number parameters
DATEDIFF	(DATEPART,DATE1,DATE2)	Returns the interval between Date1 and Date2, which is specified by the datepart parameter
Datename	(datepart,date)	Returns the string corresponding to the specified part of the date
DATEPART	(datepart,date)	Returns the integer value of the specified part of the date