how to get weekday from date in mssql code example

Example 1: sql server convert date to weekday

SELECT DATENAME( DW , GETDATE() );

Example 2: extract weekday from date in sql

SELECT WEEKDAY(date);