如何从特定日期起30天内获得确切日期？ [重复]

Question

This question already has an answer here:

• Add 2 hours to current time in MySQL? 5 answers
• Add number of days to a date 19 answers

I have mysql date like this 2013-10-16 17:44:13 and I need to get +30 days from there. I can't use eg. 10th ( month ) and change it to 11th ( month ) as this may be 31 day or 29 depending on the month

I can only think of converting 2013-10-16 17:44:13 to timestamp than + 30*24*60*30, and than this new timestamp back to mysql format

Is there a better way?

</div>

Answer 1

You can use strtotime for this:

$date = date('Y-m-d H:i:s', strtotime($date . ' +30 days'));

or do it directly in MySQL using DATE_ADD:

SELECT DATE_ADD(`date`, INTERVAL 30 DAY) as `date` FROM `table`

If you run a newer version of MySQL, you don't need to use DATE_ADD:

SELECT (`date` + INTERVAL 30 DAY) as `date` FROM `table`

Please note that while strtotime is smart enough, MySQL requires you to use DAY. Not DAYS.

Edit: I am unable to find any proof of DATE_ADD being needed in older versions, but I swear that I've heard it somewhere. Take it with a grain of salt and use whatever method you prefer.