if you have a date column 'birthdate' SELECT (birthdate + INTERVAL 7 MONTH) as birthdate FROM yourtable WHERE .......
Look at the date and time functions in the MySQL manual. -Jason Garber IonZoft.com At 02:28 PM 1/27/2002 +0000, DL Neil wrote: >Hello Sander, > > > I want to add a variable numer of months to the current date CURDATE(). > > I thought it should be something like this: > > select (MONTH(CURRENT_DATE)+MONTH(2)) > > but i get NULL as a result. > > > > The purpose of this it to check which records with a experation date is > > earlier or later than today+2 months later. > > > > Can somebody please tell me how to do this? > > >Would MySQL's ADD_DATE() suit? >=dn > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]