DATEADD(dd, -(DATEPART(dw, [Date])-1), [Date])
SELECT TO_CHAR(your_table.date_colunm, 'DAY') FROM your_table;
SELECT WEEKDAY(date);