Adding x number of days onto a mysql date

[SPYDERIX]

Hi there,

I have some fields in mysql (set as date) and I want to know if there is a php function or mysql function I could use to add on x number of days onto what I have stored. I know I could retrieve the date do a substr of it and then an mktime and then re-assemlbe and re-store but that's quite long winded. Was wondering if there is a faster/easier way to do this.

If the date is 2005-05-31 and I add 2 days onto that I need it to properly output as 2005-06-02.

Thanks for any help. I really appreciate it.

NATE

http://www.mainframehosting.net

Got a question? Search G O O G L E first.

 

[EBGreen]

From Google:

http://www.phpbuilder.com/columns/akent20000610.php3?page=5

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[SPYDERIX]

Hey TomThumbKP,

I found the answer. I can use SQL to do this.

UPDATE `table` SET `date` = DATE_ADD(`date`, INTERVAL X DAY) WHERE `id` = 1

Thanks for your time though.

NATE

http://www.mainframehosting.net

Got a question? Search G O O G L E first.