select CURRENT_DATE()+1 is returning 20101032 on Oct 31 in MySQL. How can I开发者_开发百科 fix this? The expected date is 20101101. Thank you.
use DATE_ADD(CURDATE(), INTERVAL 1 DAY)
instead
This also works. date(CURRENT_DATE+1)
select CURRENT_DATE()+1 is returning 20101032 on Oct 31 in MySQL. How can I开发者_开发百科 fix this? The expected date is 20101101. Thank you.
use DATE_ADD(CURDATE(), INTERVAL 1 DAY)
instead
This also works. date(CURRENT_DATE+1)
精彩评论