1.查询当天记录
<![CDATA[xxx]]> xxx填 > < 或者 <=
以学生表为例子
SELECT userid, username from student where createTime
BETWEEN DATE_FORMAT( DATE_SUB(NOW(), INTERVAL 0 DAY), '%Y-%m-%d 00:00:00') AND DATE_FORMAT( DATE_SUB(NOW(), INTERVAL 0 DAY), '%Y-%m-%d 23:59:59')
2.查询常用
查询5分钟内的
DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 minute),'%Y-%m-%d %H:%m:%s')
查询5天内的
DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 day),'%Y-%m-%d')
2.嵌套使用
select count(*) AS userCount,(select count(*) from student
where createTime BETWEEN DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 1 DAY), '%Y-%m-%d 00:00:00') AND DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 1 DAY), '%Y-%m-%d 23:59:59'))
as newuserCount
from student