查询今天，昨天，本周，上周，本月，上月的数据-优快云博客

本文链接：https://blog.youkuaiyun.com/jdaiwlsd/article/details/120352012

本文介绍如何使用SQL查询特定日期范围内的数据，包括今天、昨天、本周、上周、本月及上月的数据汇总方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from tj where to_days(now()) = to_days(tjsj) 
查询今天的数据
select SUM(recommend_uv) as recommend_uv 
from epg_itvb_recommend_cv_uv 
where to_days(now()) = to_days(re_date) 


select * from tj where to_days(now()) - to_days(tjsj) = 1
计算昨天的数据
select SUM(recommend_uv) as recommend_uv 
from epg_itvb_recommend_cv_uv 
where to_days(now()) - to_days(re_date) = 1

select * from tj where tjsj >= subdate(curdate(),date_format(curdate(),'%w')-1) and tjsj <= subdate(curdate(),date_format(curdate(),'%w')-7)
计算本周数据
select SUM(recommend_uv) as recommend_uv
from epg_itvb_recommend_cv_uv 
where re_date >= subdate(curdate(),date_format(curdate(),'%w')-1) 
and re_date <= subdate(curdate(),date_format(curdate(),'%w')-7)


select * from tj where tjsj >= subdate(curdate(),date_format(curdate(),'%w')+6) and tjsj <= subdate(curdate(),date_format(curdate(),'%w')-0)
计算上周的数据
select SUM(recommend_uv) as recommend_uv
from epg_itvb_recommend_cv_uv 
where re_date >= subdate(curdate(),date_format(curdate(),'%w')+6) 
and re_date <= subdate(curdate(),date_format(curdate(),'%w')-0)


select * from tj where date_format(tjsj,'%y-%m')=date_format(curdate(),'%y-%m')
计算本月数据
select SUM(recommend_uv) as recommend_uv
from epg_itvb_recommend_cv_uv 
where date_format(re_date,'%y-%m')=date_format(curdate(),'%y-%m')


select * from tj where date_format(tjsj,'%y-%m')=date_format(date_sub(curdate(), interval 1 month),'%y-%m')
计算上月数据
select SUM(recommend_uv) as recommend_uv
from epg_itvb_recommend_cv_uv
where date_format(re_date,'%y-%m')=date_format(date_sub(curdate(), interval 1 month),'%y-%m')