Calendar Tables: An Invaluable Database Tool

It's Friday, and the boss just asked you to produce a report that summarizes all the issues your team has dealt with in the past year, along with a chart that indicates at a glance the average number of business days that passed between the date an issue was reported to the date it was closed. No problem, right? But how can you reliably count only actual business days without including weekends or holidays? And to make matters worse, your company has a policy of giving employees Fridays off if a holiday falls on a Saturday, and Mondays off if one falls on a Sunday.

Subscribe to RSS - MySQL