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')
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')
本文标题:Mysql 日期比较
本文链接:https://www.haomeiwen.com/subject/oaogqqtx.html
网友评论