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"?