SELECT TO_CHAR(start_date + LEVEL - 1, 'YYYY-MM-DD') AS new_dateFROM ( SELECT TO_DATE('${计划开工日期起始}', 'YYYY-MM-DD') AS start_date, TO_DATE('${计划完工结束}', 'YYYY-MM-DD') AS end_date FROM dual)CONNECT BY LEVEL <= end_date - start_date + 1;这个是ORACLE的 一直报错不行