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]

Reply via email to