MySQL选择日期等于今天

问题描述：

我正在尝试运行mysql select语句，该语句会查看今天的日期，并且仅返回在当天注册的结果.我目前已经尝试了以下方法，但似乎无法正常工作.

I'm trying to run a mysql select statement where it looks at today's date and only returns results that signed up on that current day. I've currently tried the following, but it doesn't seem to work.

SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
    FROM users 
    WHERE users.signup_date = CURDATE()

谢谢大家，我已经修改了SELECT语句.

I've modified my SELECT statement to this, thanks guys.

SELECT id FROM users WHERE DATE(signup_date) = CURDATE()

答

SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
FROM users 
WHERE DATE(signup_date) = CURDATE()

MySQL选择日期等于今天

相关推荐