2021-04-30

How to get the previous working day from Oracle?

We maintain a table listing actual holidays for years to come (Holidays, with two columns: M_DATE, and DESCR). I need to find the most recent day before the given one, that's neither listed in that table, nor is Saturday or Sunday.

Preferably -- without a loop :) How would I do that?



from Recent Questions - Stack Overflow https://ift.tt/3vuPpjU
https://ift.tt/eA8V8J

No comments:

Post a Comment