Hello,

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?

Thanks in advance

--
Met vriendelijke groet / With Greetings,

Sander Peters

   site: http://www.visionnet.nl/
  email: mailto:[EMAIL PROTECTED]
webmail: mailto:[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