I believe it's "day" without the s. Not sure if it makes a difference, but that's how it's listed in the manual.
date_add([thedatefield],Interval 15 day) Mark -----Original Message----- From: Serge Paquin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:35 AM To: [EMAIL PROTECTED] Subject: Re: DATE function question I believe the following will work: date_add([thedatefield],Interval 15 days) I am almost sure I got the syntax right off the top of my head. Check mysql.com for "date functions" if the above doesn't work. Serge. On Wed, 26 Mar 2003 10:16:18 -0500 "Tom Ray" <[EMAIL PROTECTED]> wrote: > I have a small question about the DATE function. This is what I want to do: > > - User enters information into form and submits it to database > - When info is added to database the current date is stored ala 2003-03-26 > - Now I want to take that date 2003-03-26 and tack on either 15 or 30 days > on to it so the date in another column reads either 2003-04-10 or 2003-04-25 > > I just can't seem to figure out how to do that math right so I get the > result I'm looking for. Any thoughts or ideas? > > Thanks. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
