select rownum as NOMOR,TANGGAL from (
SELECT TRUNC(SYSDATE) + 10 - LEVEL AS TANGGAL FROM DUAL
where to_char(TRUNC(SYSDATE) + 10 - LEVEL,'D') not in ('1','7')
CONNECT BY LEVEL <= 10 order by TRUNC(SYSDATE) + 10 - LEVEL asc
)
output
NOMOR TANGGAL
1 12/20/2019
2 12/23/2019
3 12/24/2019
4 12/25/2019
5 12/26/2019
6 12/27/2019
No comments:
Post a Comment