sql - “不一致的数据类型：预期的 %s 得到了 %s”

Question

CREATE TABLE MRE_UHAUL as (

  select OUTBOUND, INBOUND, vehicle_size, rental_date as start_date
        ,TO_CHAR(TO_DATE((
           LEAD(Rental_date) over
             (partition by OUTBOUND, INBOUND, vehicle_size
                  order by OUTBOUND, INBOUND, vehicle_size, rental_date
              )),
           'YYYYMMDD')-1, 'YYYYMMDD') as end_date
        ,Rate

    from ( select OUTBOUND, INBOUND, vehicle_size, rental_date, Avg(RATE) as RATE
             from mre_competitor_data
             where competitor='UHAUL'
             group by OUTBOUND, INBOUND, vehicle_size, rental_date)

    where rental_date <= (select cpd from mre_system_parameters)

);

当我尝试运行它时，它说：

SQL 错误：ORA-00932：不一致的数据类型：预期的 DATE 得到了 NUMBER 00932。00000 -“不一致的数据类型：预期的 %s 得到了 %s”

标签： sqloracle