Posted by Execute the below SQL statement to list out the Days of the Month:
|
1 2 3 |
SELECT TRUNC(SYSDATE, 'MONTH') - 1 + LEVEL AS curent_month_days FROM dual CONNECT BY TRUNC(SYSDATE, 'MONTH') - 1 + LEVEL <= LAST_DAY(SYSDATE) |
|
1 2 3 |
SELECT TRUNC(SYSDATE, 'MONTH') - 1 + LEVEL AS curent_month_days FROM dual CONNECT BY TRUNC(SYSDATE, 'MONTH') - 1 + LEVEL <= LAST_DAY(SYSDATE) |