<div>
Although I wish that I could understand why this suddenly stopped working your solution did work.
</div>


Although I wish that I could understand why this suddenly stopped working your solution did work.

<div>
I'm glad it worked for you, MySQL 5 is just more standardized. What's with the grade?<br />
<br />
CoyotesIT
</div>


I'm glad it worked for you, MySQL 5 is just more standardized. What's with the grade?

CoyotesIT

<div>
<div class="content wysiwyg-content">
I have a query that has run for multiple years, we recently upgraded (5.0.45). &nbsp;It appears that comparing using the Date() function no longer is working correctly.<br />
<br />
Attaching the query below, the ship_dt column is a timestamp column and we are only wanting to compare the date and not the entire timestamp.<br />
<br />
As mentioned this worked perfectly fine under 4.x<br />
<br />
Any help would be greatly appreciated.<br />

<pre><code id="code-108598">SELECT DISTINCT a.orderid FROM orders a WHERE a.orderstatus=2 AND DATE(a.ship_dt)='2008-06-26'
</code></pre>
</div>
</div>


I have a query that has run for multiple years, we recently upgraded (5.0.45).  It appears that comparing using the Date() function no longer is working correctly.

Attaching the query below, the ship_dt column is a timestamp column and we are only wanting to compare the date and not the entire timestamp.

As mentioned this worked perfectly fine under 4.x

Any help would be greatly appreciated.

Comparing dates in MYSQL is not working after MYSQL upgrade

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.