SQL SERVER DATENAME FUNCTION

SQL SERVER DATENAME FUNCTION

/* DATENAME FUNCTION USING SQL SERVER SSMS */

--ALRIGHT, WE ARE LOOKING AT THE DATENAME FUNCTION TODAY IN SQL SERVER

--FIRST START WITH ENTERING THE KEYWORD, SELECT

--THE FOLLOW THIS BY THE DATENAME FUNCTION

SELECT DATENAME(DAY,GETDATE());

SELECT DATENAME(WEEK,GETDATE());

SELECT DATENAME(MONTH,GETDATE());

SELECT DATENAME(YEAR,GETDATE());

--YOU CAN SEE THE THEORY ABOVE IS:

-- SELECT FUNCTION NAME(INTERVAL, DATE);

-- SELECT CODE, AND CLICK EXECUTE OR (F5)

-- YOU CAN SEE THE ORDER OF VALUES IS BY DAY, WEEKS, MONTH, AND THEN YEAR

-- THAT IS IT