Thursday, 22 August 2013

MySQL Legacy Code using CURRENT_DATE with inaccuracies

MySQL Legacy Code using CURRENT_DATE with inaccuracies

Just inherited a bug-filled site with some issues with dates and when
things appear/disappear.
There is a lot of SQL statements using CURRENT_DATE and I believe this
could be a possible issue.
Is anyone else aware of any inaccuracies in performance using CURRENT_DATE
over, say a PHP-derived date string eg date('Y-m-d H:j',time())

No comments:

Post a Comment