SELECT DATEPART(YY,GETDATE())
Above query return current year... Look below and execute these and you come to know. I will explain these later due to little busy.
SELECT YEAR(GETDATE())
SELECT datename(month,getdate())
SELECT datename(YEAR,getdate())
SELECT datename(DAY,getdate())
SELECT datename(WEEKDAY,getdate())
SELECT datename(DAYOFYEAR ,getdate())
SELECT datename(ISO_WEEK ,getdate())
SELECT datename(ISOWK ,getdate())
SELECT DATEPART(YEAR,GETDATE())
--DATETIME VS DATEPART
SELECT DATEPART(MONTH,GETDATE()) AS [MONTH]
SELECT DATENAME(month,getdate()) AS [MONTH]
SELECT DATEPART(WEEKDAY,GETDATE()) AS [DAY]
SELECT DATENAME(WEEKDAY,getdate()) AS [DAY]
