Take the 2-minute tour ×  Could you please help me out how to
calculate the no. of business days between start date and end
date by excluding weekends & business specific holidays. Let's
say if we take start date, end date and custom holiday table
with list of holiday dates as mentioned below.  Start date
(mm/dd/yyyy hh24:mi:ss) : '10/15/2012 08:00:00'  End date
(mm/dd/yyyy hh24:mi:ss) : '10/23/2012 10:30:00'
holiday_table.business_holiday_date values (mm/dd/yyyy):
Need to calculate business days by taking into consideration of
the time portion of dates in the calculation (so can expect
business days with fractions as well ex. 1.25, 3.7 etc)
Appreciate if you can help me on this ASAP.   share|improve this
question Hello James and welcome to StackOverflow. Consider
expanding your question with what have you attempted so far. See
How to Ask for details. –  bytebuster Oct 20 '12 at 0:15 add
comment  2 Answers   SELECT(end_date - start_date) -  (select
count(*)   from holiday_table   where business_holiday_