mybatis 时间区间比较

• Date类型

        <if test="startTime != null and  startTime != ''">
            <![CDATA[ and g.create_time >= to_date(#{startTime,jdbcType=DATE},'yyyy-MM-dd hh24:mi:ss')]]>
        </if>
        <if test="endTime != null and  endTime != ''">
            <![CDATA[ and g.create_time <= to_date(#{endTime,jdbcType=DATE},'yyyy-MM-dd hh24:mi:ss')]]>
        </if>

• 字符串类型

        <if test="startTime != null and startTime != ''">
            AND combo.startTime &gt;=  #{startTime}
        </if>
        <if test="endTime != null and endTime != ''">
            AND combo.endTime &lt;=  #{endTime}
        </if>