IT
Data Calculation 12 + 1 = 13?
CEOinIRVINE
2011. 8. 26. 03:19
mysql> SELECT name, birth FROM pet
-> WHERE MONTH(birth) = MONTH(DATE_ADD(CURDATE(),INTERVAL 0 MONTH));
...so that the output will be "this week", rather than "this month"?