一小时之内的数据
where mytime >= NOW() - INTERVAL 1 HOUR;
一天之内的数据
where mytime >= NOW() - INTERVAL 1 DAY;
昨天的数据
where visittime between CURDATE()-INTERVAL 1 DAY and CURDATE();
一小时之内的数据
where mytime >= NOW() - INTERVAL 1 HOUR;
一天之内的数据
where mytime >= NOW() - INTERVAL 1 DAY;
昨天的数据
where visittime between CURDATE()-INTERVAL 1 DAY and CURDATE();
转载于:https://my.oschina.net/varusyan/blog/854280