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

You can use:

NOW() + INTERVAL 1 DAY

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

CURDATE() + INTERVAL 1 DAY

Answer 2

Try doing: INSERT INTO table(data, date) VALUES ('$data', now() + interval 1 day)

Answer 3

DATE_ADD

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add