mysql group by 时间戳,mysql 时间戳 按周、日、月 统计方法

按小时显示

select timestamp,count(*) as test from browserinfo group by date_format(timestamp, '%Y-%m-%d %H ');

查询今天,昨天,近7天,近30天,本月,上一月

select * from `browserinfo` where date_format(`timestamp`,'%Y-%m-%d') = date_format(now(),'%Y-%m-%d'); //当天

select * from `browserinfo` where to_days(date_format(`timestamp`,'%Y-%m-%d')) = to_days(now()); //当天,效果同上一条

select * from `browserinfo` where to_days(`timestamp`) = to_days(now()); //当天,效果同上两条

select * from `browserinfo` where to_days(now())-to_days(`timestamp`) <= 1; //昨天

select * from `browserinfo` where date_sub(curdate(), INTERVAL 7 DAY) <= date(`timestamp`); //最近七天

select * from `browserinfo` where date_sub(curdate(), INTERVAL 30 DAY) <= date(`timestamp`); //最近三十天

select * from `browserinfo` where date_format(`timestamp`, '%Y%m') = date_format(curdate() , '%Y%m'); //本月

select * from `browserinfo` where period_diff(date_format(now() , '%Y%m') , date_format(`timestamp`, '%Y%m')) =1; //上个月