mysql及mybatis模糊查询 时间范围查询

mysql及mybatis模糊查询 时间范围查询

mysql查询语句

SELECT
*
FROM
	tb_demo
WHERE
	DATE_FORMAT( tb_demo.date, '%Y-%m-%d %H:%i:%s' ) >= DATE_FORMAT( '2020-04-23 16:12:58', '%Y-%m-%d %H:%i:%s' ) 
ORDER BY
	tb_demo.date DESC

mybatis:动态sql

        <if test="startDate!=null and startDate!=''">
            <![CDATA[   and DATE_FORMAT(tb_demo.date, '%Y-%m-%d %H:%i:%s')>=  DATE_FORMAT(#{startDate}, '%Y-%m-%d %H:%i:%s')   ]]>
        </if>
        <if test="endDate!=null and endDate!=''">
            <![CDATA[  and DATE_FORMAT(tb_demo.date, '%Y-%m-%d %H:%i:%s') <= DATE_FORMAT(#{endDate}, '%Y-%m-%d %H:%i:%s')    ]]>
        </if>