17,090
社区成员
发帖
与我相关
我的任务
分享
SELECT a.productid, a.num, b.sdate
FROM a,
(SELECT TO_CHAR (:start_day + ROWNUM - 1, 'YYYY-MM-DD') sdate
FROM DUAL
CONNECT BY ROWNUM <= ABS(:end_day - :start_day) + 1) b
WHERE a.sdate <= b.sdate
SELECT a.productid, a.num, b.sdate
FROM a,
(SELECT TO_CHAR (TRUNC (SYSDATE, 'MM') + ROWNUM - 1,
'YYYY-MM-DD'
) sdate
FROM DUAL
CONNECT BY ROWNUM <= TO_NUMBER (TO_CHAR (SYSDATE, 'dd'))) b
WHERE a.sdate <= b.sdate