查询当天数据
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
MySQL支持查询日期格式类似shell的
date +%Y%m%d这样的方法，所以就很容易对比时间：
SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d')
FROM users
WHERE DATE(signup_date) = CURDATE()或者
SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d')
FROM users
WHERE DATE_FORMAT(users.signup_date, '%Y-%m-%d') = CURDATE()