Reputation: 8595
select CURRENT_DATE()+1 is returning 20101032 on Oct 31 in MySQL. How can I fix this? The expected date is 20101101. Thank you.
Upvotes: 1
Views: 2700
Reputation: 11
This also works. date(CURRENT_DATE+1)
date(CURRENT_DATE+1)
Reputation: 27916
use DATE_ADD(CURDATE(), INTERVAL 1 DAY) instead
DATE_ADD(CURDATE(), INTERVAL 1 DAY)
Upvotes: 7