MySQL datetime operation

Question

How to get the datetime value several days/weeks/months/years later in MySQL?

I just know the current datetime is NOW() .

Answer 1

SELECT NOW() + INTERVAL 3 DAY
SELECT NOW() + INTERVAL 5 WEEK
SELECT NOW() + INTERVAL 6 MONTH
SELECT NOW() + INTERVAL 2 YEAR

Answer 2

See the mysql time functions reference