SQL SERVER DATEDIFF FUNCTION

SQL SERVER DATEDIFF FUNCTION

/* DATEDIFF FUNCTION IN SQL SERVER SSMS */

--ALRIGHT, WE WILL BE LOOKING AT THE DATEDIFF FUNCTION IN SQL SERVER SSMS */

--FIRST WE START BY USING THE KEYWORD, SELECT

-- THEN FOLLOWED BY THE FUNCTION NAME DATEDIFF

SELECT DATEDIFF(DAY,GETDATE(),'2020-11-01');

SELECT DATEDIFF(WEEK,GETDATE(),'2020-11-01');

SELECT DATEDIFF(MONTH,GETDATE(),'2020-11-01');

SELECT DATEDIFF(YEAR,GETDATE(),'2020-11-01');

-- THE THEORY IS SELECT DATEDIFF(INTERVAL,START DATE, END DATE);

-- NOW HIGHLIGHT THE CODE AND CLICK EXECUTE OR (F5)

-- YOU CAN SEE THE RESULTS BELOW IN DAYS, WEEKS, MONTHS, YEARS

-- THAT IS IT