SELECT A.REMARK_NAME,
A.REMARK_START_DATE,
A.REMARK_END_DATE,
A.REMARK_START_DATE + B.DIS - 1 H
FROM B_REMARK_DETAIL A,
(SELECT ROWNUM DIS
FROM (SELECT MAX(REMARK_END_DATE - REMARK_START_DATE) + 1 GAP
FROM B_REMARK_DETAIL)
CONNECT BY ROWNUM <= GAP) B
WHERE A.REMARK_END_DATE >= A.REMARK_START_DATE + B.DIS - 1
ORDER BY H
【oracle】获得两个日期之间的所有日期
最新推荐文章于 2024-06-06 14:27:37 发布