mysql stored procedure create date plus one day but time set to 00:00:00
A cleaner method would be to add zero seconds to today's date + 1 day

mysql&gt; SELECT CURDATE() today,
    -&gt; CURDATE() + INTERVAL 1 DAY + INTERVAL 0 SECOND midnight_tomorrow;
+------------+---------------------+
| today      | midnight_tomorrow   |
+------------+---------------------+
| 2014-09-14 | 2014-09-15 00:00:00 |
+------------+---------------------+
1 row in set (0.00 sec)

mysql&gt;