Javatpoint Logo
Javatpoint Logo

T- SQL- Date Functions

In T-SQL, Date functions are used to generate the query for date and time.

GETDATE ():

GETDATE () returns the current date with the time.

Syntax:

The syntax of the function-

Example

The query will return the current date in T-SQL.

DATEPART ()

It gives the part of the date or time.

Syntax

The syntax of the function -

Example

The query returns the part of the current month in T-SQL.

DATEADD ()

It displays the date and time by subtracting or adding the date and time interval.

Syntax

The syntax for the function -

Example

The query below will return after the date and time of ten days from the current date and time in T-SQL.

DATEDIFF()

DATEDIFF () displays the date and time between one or many dates.

Syntax:

Example

The query below returns the gap of hours between 2020-10-12 and 2020-10-09 in MS SQL Server.

CONVERT ()

It displays the date and time in various formats.

Syntax:

Example

The queries return the date and time in many formats in Transact-SQL.






Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA