一、今日数据统计:
@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