SELECt * FROM tableWHERe exec_datetime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();
http://dev.mysql.com/doc/refman/5.5/zh-CN/date-and-time-
functions.html#function_date-add
SELECt * FROM tableWHERe exec_datetime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();
http://dev.mysql.com/doc/refman/5.5/zh-CN/date-and-time-
functions.html#function_date-add
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
