oracle sql 时间比较_oracle todate格式

     from BCS\_EXCEPTION\_LOG t

     where 1=1

     <if test="topic != null and topic !=''">

         and t.f\_topic like concat(concat('%',#{topic}),'%')

     </if>

     <if test="receiveStartTime != null and receiveStartTime !=''">

         and t.f\_receivedate >= to\_date(#{receiveStartTime},'yyyy-mm-dd hh24:mi:ss')

     </if>

     <if test="receiveEndTime != null and receiveEndTime !=''">

         and t.f\_receivedate <= to\_date(#{receiveEndTime},'yyyy-mm-dd hh24:mi:ss')

     </if>

     order by t.f\_receivedate desc