Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find Last two business days of the month

Ann 81Nov 3 2021

How to find the last two business days of the current month in sql? This is for a pl/sql code;
if sysdate belongs to the last two business days (Monday to Friday) then
skip the pl/sql block;
end if;

        For eg:  in  2022 the highlighted dates are last two business days  

Last two business days.png (47.89 KB)

This post has been answered by Frank Kulash on Nov 3 2021
Jump to Answer
Comments
Post Details
Added on Nov 3 2021
6 comments
1,049 views