oracle

  <if test="djsj!=null and djsj!=''">
            and DJSJ <![CDATA[>=]]> (to_date(#{
   djsj, jdbcType=VARCHAR},'yyyy-MM-dd yyyy-MM-dd hh24:mi:ss'))
        </if>
        <if test="djsj!=null and djsj!=''">
            and DJSJ <![CDATA[<]]> (to_date(#{
   djsj, jdbcType=VARCHAR},'yyyy-MM-dd hh24:mi:ss'))+1
        </if>

对应的字段数据库中保存的类型是 Data

mysql

   <if test="cysjkssj != null and cysjkssj != ''">
            and  cysj <![CDATA[>=]]> DATE_FORMAT(#{
   cysjkssj,jdbcType=VARCHAR},'%Y-%m-%d hh24:mi:ss')
        </if>
        <if test="cysjjssj != null and cysjjssj != ''">
            and  cysj <![CDATA[>=]]> DATE_FORMAT(#{
   cysjjssj,jdbcType=VARCHAR},'%Y-%m-%d %H:%i:%s')
        </if>

对应的字段数据库中保存的类型是 Data

注意： oracle时间的转换格式是’yyyy-MM-dd hh24:mi:ss’
MySQL时间的转换格式是’%Y%m%d’ %H:%i:%s