How to Get Day Name From Today's Date?
Satyaprakash Samantaray
select DATENAME(weekday,GETDATE()) 'Day Name'
SELECT DATENAME(weekday,GETDATE()) AS [DayName]