MySQL查询本周、上周、本月、上个月份数据的sql代码 查询当前这周的数据SELECTname,submittimeFROMenterpriseWHEREYEARWEEK(date_format(submittime,'%Y-%m-%d'))=YEARWEEK 上周