SQL SERVER DATEADD FUNCTION

SQL SERVER DATEADD FUNCTION

/* DATEADD FUNCTION IS SQL SERVER SSMS */

--ALRIGHT, WE ARE LOOKING AT THE DATEADD FUNCTION TO ADD INTERVALS TO THE CURRENT DATE

-- START WITH USING THE KEYWORD SELECT

-- FOLLOWED BY THE FUNCTION NAME DATEADD

SELECT DATEADD(DAY,20,GETDATE());

SELECT DATEADD(WEEK,20,GETDATE());

SELECT DATEADD(MONTH,20,GETDATE());

SELECT DATEADD(YEAR,20,GETDATE());

-- SO YOU CAN SEE FROM THE CODE ABOVE THAT 20 DAYS, WEEKS, MONTHS, AND YEARS ARE GOING TO BE

-- ADDED SUCCEDINGLY BY ORDER OF EACH CODE ABOVE

-- SO SELECT THE CODE AND PRESS EXECUTE OR (F5)

-- YOU CAN SEE THE RESULTS BELOW

-- THAT IS IT