56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> select curdate(),curdate()-interval 30 day;
+------------+---------------------------+
| curdate() | curdate()-interval 30 day |
+------------+---------------------------+
| 2009-11-03 | 2009-10-04 |
+------------+---------------------------+
1 row in set (0.00 sec)
mysql>
datediff(curdate(),day)<30