每周第一天:
SELECT CURDATE(), DATE_ADD(CURDATE(),INTERVAL -WEEKDAY(CURDATE()) DAY);
每月第一天:
SELECT CURDATE(), DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY);
每周第一天:
SELECT CURDATE(), DATE_ADD(CURDATE(),INTERVAL -WEEKDAY(CURDATE()) DAY);
每月第一天:
SELECT CURDATE(), DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY);