SQL DateTime Commands

Intro

There are many Date/Time functions in SQL SERVER including:

• GETDATE()
• DATEADD()
• DATEDIFF()
• DATEPART()
• ISDATE()
• ...

GETDATE()

Use GETDATE() to return the current date and time

Syntax

GETDATE()

SELECT GETDATE()

DATEADD()

Use DATEADD() to add a specific time to a date and return it

Syntax

DATEADD(interval, number, date)

SELECT DATEADD(year, 1, GETDATE()) AS DateAdd;

DATEDIFF()

Use DATEDIFF() to return the difference between two dates

Syntax

DATEDIFF(interval, date1, date2)

SELECT DATEDIFF(year, '1979/10/08',  GETDATE()) AS DateDiff;