56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM `clir_register` WHERE Diagnosist_Time<ADDDATE(CURRENT_DATE,INTERVAL -1 Day)
mysql> select adddate('2018/07/01',interval -1 year);
+----------------------------------------+
| adddate('2018/07/01',interval -1 year) |
+----------------------------------------+
| 2017-07-01 |
+----------------------------------------+
1 row in set (0.00 sec)