CODEWITHSUNDEEP
sqlmysql
user243655
user243655

Reputation: 8595

current_date()+1 is returning invalid date

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

Answers (2)

Anbarasan
Anbarasan

Reputation: 11

This also works. date(CURRENT_DATE+1)

Upvotes: 1

Brad Mace
Brad Mace

Reputation: 27916

use DATE_ADD(CURDATE(), INTERVAL 1 DAY) instead

Upvotes: 7

Related Questions