how do you knock off bank holidays, saturdays and sundays for pay dates
29240Apr 9 2006 — edited Apr 11 2006Hi, there,
For simplicity, lets not go a far as bank holidays, at least I want to be able to run a job not using the DBMS.jobs package but on a trigger.
I want payments to go through at least on the 28th day of every month but it might fall on a weekend.
1* SELECT TO_CHAR(TRUNC(SYSDATE, 'MM')+27) FROM DUAL
SQL> /
TO_CHAR(T
---------
28-APR-06
Do you think it can be done to push payment to the next working day if it falls on a weekend.
What do you think is best practise.
Contributions will be highly appreciated.
This is for learning purposes
cube60.