使用如下
查询当前季度的数据
<select id="selAccumulativeTotalByQuarter" resultType="java.util.Map">
select a.park_id,b.park_img,b.park_name,sum(a.tourists) as sum from octv_board_park_statistics a inner join octv_park_basic b on a.park_id = b.id where QUARTER(a.count_date) = QUARTER(NOW()) AND YEAR (a.count_date) = YEAR (NOW()) group by a.park_id order by sum desc limit 5
</select>
查询本周所有的数据第一天是周一
SELECT * FROM task WHERE YEARWEEK(date_format(时间字段,'%Y-%m-%d'),1) = YEARWEEK(now(),1);
查询本周所有的数据第一天是周日
SELECT * FROM task WHERE YEARWEEK(date_format(时间字段,'%Y-%m-%d')) = YEARWEEK(now());
SELECT YEAR (NOW()) 获取年度
QUARTER (时间字段名)= QUARTER (DATE_SUB( now(), INTERVAL 0 QUARTER )) 查询的是每一年的当前季度数据总和
SELECT * FROM 表名 WHERE QUARTER(时间字段名) = QUARTER(NOW()) 查询的是每一年的当前季度数据总和
当前季度
QUARTER(时间字段名)=QUARTER (now()) AND YEAR (时间字段名) = YEAR (NOW()) ");
SELECT * FROM 表名 WHERE QUARTER(时间字段名) = QUARTER(NOW()) AND YEAR (时间字段名) = YEAR (NOW()) (加上限定的年份)查询的是本年度当前季度数据
上季度
QUARTER(时间字段名)=QUARTER(DATE_SUB(now(),interval 1 QUARTER)) 查询的是每一年的上季度数据总和
QUARTER(时间字段名)=QUARTER(DATE_SUB(now(),INTERVAL 1 QUARTER)) AND year(时间字段名)=year(DATE_SUB(now(),INTERVAL 1 QUARTER)) (加上限定年份)查询的是本年度上季度数据
参考原文链接 http://t.zoukankan.com/duoyan-p-14606170.html