查询今天，昨天，本周，上周，本月，上月的数据

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')