SQL

how to get weekday from old date in sql

select format(columnName, 'dddd') as WeekDay from tableName; -- SQL Server 17

get monday of current week sql

SELECT CURDATE() - INTERVAL WEEKDAY(CURDATE()) DAY AS startweek;

sql current day of week number

SELECT DAYOFWEEK(NOW());

Get monday of week date is in SQL

DateAdd(day, (-1* (DatePart(weekday, TIMESTAMP)  % 7)) + 2, TIMESTAMP)
-- If first day is sunday in SQL 

extract weekday from date in sql

SELECT WEEKDAY(date);

get week day from date in sql

SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;

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]