<if test="pojo.begintime!=null and pojo.begintime!=''">
<![CDATA[ and DATE_FORMAT(tr.summary_date, '%Y-%m-%d')>= DATE_FORMAT(#{pojo.begintime}, '%Y-%m-%d') ]]>
</if>
<if test="pojo.endtime!=null and pojo.endtime!=''">
<![CDATA[ and DATE_FORMAT(tr.summary_date, '%Y-%m-%d') <= DATE_FORMAT(#{pojo.endtime}, '%Y-%m-%d') ]]>
</if>
mybatis查询时间段sql语句
最新推荐文章于 2024-05-15 04:22:37 发布