Friday, 20 December 2019

Oracle Menampilkan Tanggal Hari Kerja


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