DATEPART VS DATENAME

SELECT DATEPART(MONTH,GETDATE()) AS [MONTH]


--Result
8
SELECT DATENAME(month,getdate()) AS [MONTH]
--Result
Auguest
SELECT DATEPART(WEEKDAY,GETDATE()) AS [DAY]
--Result
6
SELECT DATENAME(WEEKDAY,getdate()) AS [DAY]
--Result
Friday