- -- I need to get the a total number of business days (from monday to
- -- friday) between two dates.
- -- Someone can help me please.
A simplistic approach that counts a "business day" as being Monday
through Friday would be something like this:
However, you quickly run into the problem of holidays. While you
could construct a helper table listing all the holidays, ones that
don't fall on the same day every year (e.g. Easter) will trip
you up.
Er, isn't Easter usually on a Sunday? Anyway, I also found this, the
first hit if you google "sql holidays":
http://www.sqlmag.com/Article/ArticleID/25899/sql_server_25899.html
The big ugly union might need to be munged a bit, but most of the non-
weekend US holidays seem to be there.
- John D. Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
