Find Day Name From Date in SQL Server

Hi makenzi.exc,

Use the FORMAT function of SQL Server.

Refer below example.

SQL

DECLARE @Date DATE = '2021-12-24';
SELECT @Date As [Date],  
       FORMAT(@Date, 'ddd') [DayName]

SELECT @Date As [Date],  
       FORMAT(@Date, 'dddd') AS [DayName]

Screenshot