MySQL's now() +1 day

Question

I'm using now() in MySQL query.

INSERT INTO table SET data = '$data', date = now()

But I want to add 1 day to this date (so that date should contain tomorrow).

Is it possible?

Answer 1

Try this code:

NOW() + INTERVAL 1 DAY

You can use CURDATE instead of NOW, If you are only interested in the date not in the date and time.

CURDATE() + INTERVAL 1 DAY