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

makenzi....

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

dharmend...

0 1

To get the Week Day name use the DATENAME function with datepart as WEEKDAY.

Refer below query.

SQL

DECLARE @Date DATE = '2025-03-11'
SELECT @Date [Date],  
DATENAME(WEEKDAY, @Date) AS [DayName]

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Description

Description is required.