Loading
How to Get Day Name From Today's Date?
4 Answers
DATENAME() function
DECLARE @Date DATE = getdate()
SELECT @Date As [TDate],
DATENAME(WEEKDAY, @Date) AS [Day_Name];
Shashidhar RPosted Oct 26, 2024, 9:35 AM
select DATENAME(weekday,GETDATE()) ‘Day Name’
Rajeev KumarPosted Apr 6, 2023, 12:15 PM
SELECT DATENAME(weekday,GETDATE()) AS [DayName]
Khan Abrar AhmedPosted Sep 7, 2017, 8:25 AM
select DATENAME(weekday,GETDATE()) 'Day Name'
Satyaprakash SamantarayPosted Feb 7, 2017, 2:31 AM