Yup I think that's write. I had a feeling I had something small wrong :) On Wed, 26 Mar 2003 13:50:12 -0500 "Mark Armendariz" <[EMAIL PROTECTED]> wrote:
> 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
