SELECT date_sub(curdate(),INTERVAL WEEKDAY(curdate()) DAY) from dual; SELECT date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 6 DAY) from dual;