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]

Reply via email to