话不多说,直接上sql
String yearDay = "2023-01-20"
<![CDATA[ AND DATE_FORMAT(create_time, '%Y-%m-%d') = DATE_FORMAT(#{yearDay,jdbcType=DATE},'%Y-%m-%d')]]>
话不多说,直接上sql
String yearDay = "2023-01-20"
<![CDATA[ AND DATE_FORMAT(create_time, '%Y-%m-%d') = DATE_FORMAT(#{yearDay,jdbcType=DATE},'%Y-%m-%d')]]>