MySQL查询本周、上周、本月、上个月份数据的sql代码

!--NEWSZW_HZH_BEGIN-- 查询当前这周的数据
SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,"%Y-%m-%d")) = YEARWEEK(now()); SELECT name,submit