Last updated 5 years ago
Was this helpful?
经常要查询日志数据库中最近1小时加入的数据,结合DATE_SUB()和NOW()函数方法如下:
DATE_SUB()
NOW()
select count(*) as cnt from log where date >= DATE_SUB(NOW(),INTERVAL 1 HOUR);
可以使用(now() - interval 30 minute)
(now() - interval 30 minute)
select count(*) as cnt from log where date >= (NOW() - INTERVAL 30 minute);
使用DATE_SUB()函数也可以:
select count(*) as cnt from log where date >= DATE_SUB(NOW(), INTERVAL 30 minute);