Friday, April 20, 2012

Calculate business hours between two dates

How can I calculate business hours between two dates?
For example we have two dates; 01/01/2010 15:00 and 04/01/2010 12:00
And we have working hours 09:00 to 17:00 in weekdays
How can I calculate working hours with sql?





No comments:

Post a Comment