mysql实现周月表_Mysql Mybatis做时间过滤报表:日周月统计

声明：classType------0：今日，1：周，2：月，3：自定义，4：最近七天

AND DATE_FORMAT(s.create_time,'%Y%u') = DATE_FORMAT(CURDATE( ),'%Y%u')

AND DATE_FORMAT(s.create_time,'%Y%m') = DATE_FORMAT(CURDATE( ),'%Y%m')

AND Date(s.create_time) between #{beginTime,jdbcType=VARCHAR} and CURDATE()

AND Date(s.create_time) <= #{endTime,jdbcType=VARCHAR}

AND Date(s.create_time) between #{beginTime,jdbcType=VARCHAR} and #{endTime,jdbcType=VARCHAR}

AND Date(s.create_time) = CURDATE()

AND date(s.create_time) between date_sub(curdate(), INTERVAL 6 DAY) and curdate()

AND Date(s.create_time) = CURDATE()