Showing posts with label get Weekday in SQL Server. Show all posts
Showing posts with label get Weekday in SQL Server. Show all posts

Get current Year in SQL SERVER

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]