mysql按时间获取数据

最新推荐文章于 2022-07-30 19:52:56 发布

「已注销」

最新推荐文章于 2022-07-30 19:52:56 发布

阅读量620

点赞数

/*
获取今年所有数据
*/
select * from my_date where YEAR(date_f)=YEAR(CURDATE())
/*
获取去年所有数据
*/
select * from my_date where YEAR(date_f)=YEAR(DATE_SUB(CURDATE(),interval 1 year))

/*
获取本季度所有数据
*/
select * from my_date where QUARTER(date_f)=QUARTER(CURDATE());

/*
获取上一个季度所有数据
*/
select * from my_date where QUARTER(date_f)=QUARTER(DATE_SUB(CURDATE(),interval 1 quarter));

/*
获取本月所有数据
*/
select * from my_date where YEAR(date_f)=YEAR(CURDATE()) and MONTH(date_f)=MONTH(CURDATE())
/*
获取上月所有数据
*/
select * from my_date where YEAR(date_f)=YEAR(CURDATE()) and MONTH(date_f)=MONTH(DATE_SUB(CURDATE(),interval 1 month))