SELECT TO_CHAR(start_date + LEVEL - 1, 'YYYY-MM-DD') AS new_date FROM ( 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的 一直报错不行 |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
