SQL get week start date from week number code example
Example 1: sql server week number
datepart(wk, DateToParse)
Example 2: get week day from date in sql
SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;
datepart(wk, DateToParse)
SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;