dATE Functions

change current date to past date

DATEADD(DAY, -30, GETDATE())  -- this will set date to previous 30 days

SELECT GETDATE()

SELECT YEAR(GETDATE())

SELECT MONTH(GETDATE())

SELECT DAY(GETDATE())

SELECT MONTH('2022-08-02')

DATEADD()

DATEPART()

DATEDIFF()

ISDATE()