年月日数据统计sql

一、今日数据统计：
@Select(“select count(1) from tb_product t where to_days(t.create_time) = to_days(now());”)

二、昨日数据统计：
@Select(“SELECT count(1) FROM tb_product t WHERE TO_DAYS( NOW( ) ) - TO_DAYS( t.create_time)= 1 “)

三、本周数据统计：
@Select(“SELECT count(1) FROM tb_product t WHERE YEARWEEK(date_format(t.create_time,’%Y-%m-%d’)) = YEARWEEK(now());”)

四、本月数据统计：
@Select(“SELECT count(1) FROM tb_product t WHERE DATE_FORMAT( t.create_time, ‘%Y%m’ ) = DATE_FORMAT( CURDATE( ) , ‘%Y%m’ )”)

五、年度查询数据：
SELECT count(1)
FROM tb_product
WHERE year(create_time) = year( curdate( ))

六、整体数据统计查询sql参考一下链接：
https://blog.csdn.net/u010543785/article/details/52354957