Get week day name from month day and year in SQL Server

Question

How to get week day name from month day and year in SQL Server

dharmendr · Accepted Answer

Hi makenziexcTo get the Week Day name use the DATENAME function with datepart as WEEKDAYRefer below querySQLDECLARE Date DATE  392025031139SELECT Date Date  DATENAMEWEEKDAY Date AS DayNameScreenshot

Get week day name from month day and year in SQL Server

Company

Explore

Follow us

Contact Us