mysql 查询前一天20点到今天20点的数据

查询前一天20点到今天20点的数据

select count(*) from student WHERE add_time >= CONCAT(DATE_FORMAT(DATE_SUB(now(),INTERVAL 1 DAY),'%Y-%m-%d'),' 20:00:00') AND add_time <= CONCAT(DATE_FORMAT(DATE_SUB(now(),INTERVAL 0 DAY ),'%Y-%m-%d'),' 20:00:00');

查询当天的数据

select count(*) from student where add_time BETWEEN CONCAT(CURDATE(),' 00:00:00') AND CONCAT(CURDATE(),' 23:59:59');