CODEWITHSUNDEEP
mysql
shantanuo
shantanuo

Reputation: 32220

extracting date from datetime column

If the column TxnDate is datetime type shouldn't the first query work just as the second one?

(02:13) mysql>select * from Response where date(TxnDate) = '2010-02-05';
Empty set (0.11 sec)

(02:14) mysql>select * from Response where trim(date(TxnDate)) = '2010-02-05';
...
...
207 rows in set (0.12 sec)

I can not reproduce this problem. But the query related to this table is getting affected. version - 5.0.45

Upvotes: 3

Views: 913

Answers (1)

shantanuo
shantanuo

Reputation: 32220

Seems that it has to do something with the bug No. 29898

http://bugs.mysql.com/bug.php?id=29898

Upvotes: 1

Related Questions