SQL SERVER DAY FUNCTION

SQL SERVER DAY FUNCTION

/* DAY FUNCTION IN SQL SERVER SSMS */

--ALRIGHT, WE ARE LOOKING AT THE DAY FUNCTION IN SSMS WHICH IS A DATE AND TIME FUNCTION

--FIRST START WITH THE KEYWORD, SELECT

-- FOLLOWED BY THE FUNCTION NAME

SELECT DAY(GETDATE());

--THE THEORY IS SELECT FUNCTION NAME(TODAY'S DATE AS A BUILT IN FUNCTION);

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

-- SO THE DAY OF THE DATE TODAY IS THE 14TH.

-- THAT IS IT.