1、上周开始时间:
SELECT DATE_FORMAT(DATE_SUB(DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE()) DAY),INTERVAL 1 WEEK),'%Y-%m-%d 00:00:00');
2、上周结束时间:
SELECT DATE_FORMAT(SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 1), '%Y-%m-%d 23:59:59');
3、本月第一天:
select date_add(curdate(),interval -day(curdate())+1 day);
4、本月最后一天:
SELECT LAST_DAY(CURDATE());
5、上个月第一天:
SELECT DATE_SUB(CURDATE() - day(CURDATE()) + 1, interval 1 month);
6、上个月最后一天:
SELECT DATE_SUB(LAST_DAY(CURDATE()),INTERVAL 1 month);
7、下个月第一天:
SELECT DATE_ADD(CURDATE() - day(CURDATE()) + 1, interval 1 month);
8、下个月最后一天:
SELECT DATE_ADD(LAST_DAY(CURDATE()),INTERVAL 1 month);
9、本月天数:
SELECT DAY(LAST_DAY(CURDATE()));
10、本月已过天数:
SELECT DAY(CURDATE());
11、本月剩余天数:
SELECT DAY(LAST_DAY(CURDATE()))-DAY(CURDATE());