上一篇讲了如何获取天、周、月等数据,本篇介绍一下如何获取季度、年度数据,以及一些特殊的日期需求
1、本季度
QUARTER(CURDATE())
示例:
select *
from tablename
where
QUARTER(time_ziduan)= QUARTER(CURDATE())
2、上季度
QUARTER(DATE_SUB(CURDATE(),INTERVAL1QUARTER))
示例:
select *
from tablename
where
QUARTER(time_ziduan)= QUARTER(DATE_SUB(CURDATE(),INTERVAL 1 QUARTER))
3、本年度
YEAR(CURDATE())
或
YEAR(NOW())
示例:
select *
from tablename
where
YEAR(time_ziduan)=YEAR(CURDATE())
4、上年度
YEAR(DATE_SUB(CURDATE(),INTERVAL1YEAR))
或
YEAR(DATE_SUB(NOW(),INTERVAL1YEAR))
示例:
select *
from tablename
where
YEAR(time_ziduan)=YEAR(DATE_SUB(CURDATE(),INTERVAL1YEAR))
5、特殊日期需求