Mysql查询当前年份、去年，当前季度、上个季度，当前月份、上个月份新增数据

查询当前年份新增数据

select * from test where YEAR(create_time) = YEAR(NOW())

查询当去年份新增数据

select * from test where YEAR(create_time) = YEAR(NOW())-1

查询当前季度新增数据

select * from test where QUARTER(create_time) = QUARTER(NOW()) AND YEAR (create_time) = YEAR (NOW())

查询上个季度新增数据

select * from test where QUARTER(create_time) = QUARTER(DATE_SUB(now(),interval 1 QUARTER))

查询本月新增数据

select * from test where DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )

查询上个月新增数据

select * from test where DATE_FORMAT(create_time,'%Y%m') = DATE_FORMAT(DATE_SUB(curdate(), interval 1 MONTH),'%Y%m')