SQL Server – Calculating Business Days Between Two Dates (With Holiday Exclusion)

Note: The post is the same as the previous one for Oracle but this is for SQL Server. Although the date arithmetic gets a little complicated by the SQL Server syntax, the concept is the same. If you search the web on how to calculate the number of business days between two dates in SQL … Continue reading SQL Server – Calculating Business Days Between Two Dates (With Holiday Exclusion)

Oracle – Calculating Business Days Between Two Dates (With Holiday Exclusion)

If you search the web on how to calculate the number of business days between two dates in Oracle, you would see so many results. Here is one more with some explanation to go with it. There is no magic to it. It is simple and straight-forward and this is as basic as it can … Continue reading Oracle – Calculating Business Days Between Two Dates (With Holiday Exclusion)