sql:
select * from Biz_ExamCollection where collectionType = 5 AND date_format(createDTM,'%Y-%m-%d') <= date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y-%m-%d')
posted on 2019-07-17 11:28 手撕高达的村长 阅读(8338) 评论(0) 编辑 收藏 举报