SQL SELECT * FROM datetime = CURDATE（）返回一个空的结果集(SQL SELECT * FROM datetime = CURDATE() return an emp

SQL SELECT * FROM datetime = CURDATE（）返回一个空的结果集(SQL SELECT * FROM datetime = CURDATE() return an empty result set) mysql

谁能告诉我我的错误在哪里？ 通过使用该查询，它应该返回一些数据有datetime ='2012-10-12'的行吗？ 这是我的参考

我的日期时间列='YYYY-MM-DD HH：MM：SS'，数据类型=日期时间。

我正在使用XAMPP v1.8.0，MySQL v5.5.25a。

Can anyone tell me where's my mistake? By using that query, it should return some rows where the data have datetime = '2012-10-12' right? Here is my reference

My datetime column = 'YYYY-MM-DD HH:MM:SS', data type = datetime.

I am using XAMPP v1.8.0, MySQL v5.5.25a.

最满意答案

通过使用DATE()尝试CAST ing datetime date

SELECT * FROM tableName WHERE DATE(`datetime`) = DATE(CURDATE())

YYYY-MM-DD HH:MM:SS不等于YYYY-MM-DD

2012-01-01 12:12:12 is not equal to 2012-01-01 00:00:00

Try CASTing datetime to date by using DATE()

SELECT * FROM tableName WHERE DATE(`datetime`) = DATE(CURDATE())

YYYY-MM-DD HH:MM:SS is not equal to YYYY-MM-DD

2012-01-01 12:12:12 is not equal to 2012-01-01 00:00:00