A web developer's blog. PHP, MySQL, CakePHP, Zend Framework, Wordpress, Code Igniter, Django, Python, CSS, Javascript, jQuery, Knockout.js, and other web development topics.

Tag Archives: sum

MySQL: Doing calculations on dates excluding weekends

Posted on August 14, 2009 by Wenbert Del Rosario

I recently had to calculate the amount of work done by an employee between a specific date range. My problem was that the calculation must exclude the weekends. I asked around (both Google and #mysql in IRC) and found out … Continue reading →

Posted in General | Tagged , , , , | 3 Comments