SELECT DATENAME(DW,GETDATE()) as DayName

SELECT DATENAME(dw,'05/10/1991') as theDayName

select datename(dw,getdate()) --Thursday select datepart(dw,getdate()) --2

DECLARE @Date DATE = 'any date' SELECT @Date As [TDate], DATENAME(WEEKDAY, @Date) AS [Day_Name];

SELECT DATENAME(dw,GETDATE()) as Dayname

SELECT DATENAME(weekday,CAST('08/09/2017' AS date)) AS [DayName]

//default locale System.DateTime.Now.DayOfWeek.ToString(); //localized version System.DateTime.Now.ToString("dddd");