how to get weekday from old date in sql
select format(columnName, 'dddd') as WeekDay from tableName; -- SQL Server 17
get week day from date in sql
SELECT TO_CHAR(your_table.date_colunm, 'DAY') FROM your_table;
extract weekday from date in sql
SELECT WEEKDAY(date);
sql server get week dates from week number
SELECT DATEADD(DAY, 2 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_Start_Date], DATEADD(DAY, 8 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_End_Date]
Source: www.c-sharpcorner.com