I am running the following query in MySQL 5.0.45.
It would appear as though CURDATE and DATE do not compare to each other properly.
Here is my query: SELECT count(*) as shipped FROM orders WHERE date( ship_dt ) = curdate( )
The issue is that it is not comparing the two dates at all and ignoring it altogether. If I run SELECT date(ship_dt), currdate FROM orders
The dates look correct but they will not compare in the where clause.
ship_dt is set to DATETIME.
This is probably something smple...running 5.0.45.