SQL - Calculating Date Offset While Excluding Weekends
In a current project, I needed to calculate the date offset while excluding weekends. Initially, this was solved using a loop in PL/SQL, which I consider a less efficient approach.
To optimize it, I created a straightforward SQL query that handles th...
blog.lucashir.eu2 min read
Jared C
Software Developer
This is great, thank you. Curious if you've figured out how to do this while also excluding Holidays?