mysql 统计当前年度、月度、周数据

最新推荐文章于 2023-09-17 15:42:29 发布

原创最新推荐文章于 2023-09-17 15:42:29 发布 · 756 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

39 篇文章

订阅专栏

本文介绍如何使用SQL查询按年、季度、月和周筛选特定时间范围内的数据，通过实例演示了精确的时间过滤方法。

-- select * from news_xyh_praise WHERE year(create_time) = year(curdate( ))
-- select * from news_xyh_praise WHERE quarter(create_time)= quarter( curdate( )) and  year(create_time) = year(curdate( ))
-- select * from news_xyh_praise WHERE month(create_time)=month(curdate( )) and year(create_time) = year(curdate())

-- select * from news_xyh_praise where month(create_time) = month(curdate()) and week(create_time) = week(curdate())