At 8:14 PM +0200 11/6/99, Yona Shlomo Cn1w00 Ohana Roni wrote:
> mysql> SELECT name, birth FROM pet
> -> WHERE MONTH(birth) = MOD(MONTH(NOW()),12) + 1;
> the bug, IMHO, is that the `+1' should be right after the NOW()
>instead of it's current place.
> just read the manual at chapter 8 section 3.4.6
> put the +1 after NOW() instead of its current palce.
The output from MOD(exr,12) will always be 0-11.
The output from MONTH(date) is always 1-12.
Paul DuBois, paul@stripped