Help with Dates

2001-01-22 Thread Mike Podlesny
I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36,

Re: Help with Dates

2001-01-22 Thread Richard Ellerbrock
Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the manual. -- Richard Ellerbrock [EMAIL PROTECTED] Mike Podlesny [EMAIL PROTECTED] 2001/01/22 03:01:10 I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the