Date Functions

Introduction To Date Functions In SQL

Introduction:
In this article, you will learn what Date Functions are in SQL?

SQL Date function is used to hold the date. Each database includes many schemes for the data and in RDBMS, each record has many date functions. All syntax of the functions are unique for the database, when the function is called.

The Datepart Function

Datepart function returns the area of DateTime field.

Syntax

The basic syntax for "Datepart" date function is as follows:

DATEPART ([Date part], [Datetime])

We can use some data type for DateTime function in SQL Server database. These data types are as follows:

• DATEADD()

• DATEDIFF()

• DATENAME()

• DATEPART()

• DAY()

• GETDATE()

• MONTH()

• YEAR()

DATEADD()
DATEADD() function is used to add or subtract the date-time. It gives a new date-time, based on add or subtract interval.

DATEDIFF()

DATEDIFF() function is used to find the difference between the two days.

DATENAME()

DATENAME() function is used to find the name with the help of DateTime value.

DATEPART()

DATEPART() function is used to divide the date or time.

Day()

Day() function is used to find the day from any DateTime value.

GETDATE()

GATEDATE() function returns the date and time of the system and it does not contain any parameter.

MONTH()

MONTH() function is used to find the month from any DateTime value.

YEAR

YEAR function is used to find the year from any DateTime value.

Summary:
Thus, we learnt, date function command holds the date in SQL.