Re: counting with CURDATE() - please help!
| From: | DL Neil | Date: | Sun, 27 Jan 2002 14:28:28 +0000 |
| Subject: | Re: counting with CURDATE() - please help! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16213@lists.php.net to get a copy of this message | ||
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