oracle数据库时间比较 todate

select *
        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 &gt;= to_date(#{receiveStartTime},'yyyy-mm-dd hh24:mi:ss')
        </if>
        <if test="receiveEndTime != null and receiveEndTime !=''">
            and t.f_receivedate &lt;= to_date(#{receiveEndTime},'yyyy-mm-dd hh24:mi:ss')
        </if>
        order by t.f_receivedate desc

 

参数格式：2019-05-19 14:02:38(String)