Mysql 日期比较
2018-11-27 本文已影响0人
M_ENG
STR_TO_DATE(DATE_FORMAT(APPLYDATE,'%Y-%m-%d'),'%Y-%m-%d') >= STR_TO_DATE(#{startRecordDate},'%Y-%m-%d')
STR_TO_DATE(DATE_FORMAT(APPLYDATE,'%Y-%m-%d'),'%Y-%m-%d') <= STR_TO_DATE(#{endRecordDate},'%Y-%m-%d')
