Working days between two firefighter dates
I need to count working days between two dates in firebird database (ver 2.5)
I have a table (table_date) with workdays (date, day - free / work) and I have another table with start_date and end_date. For example, we have two dates start_date = 2015-04-04 and end_date = 2015-04-10. Day 2015-04-05 and 2015-04-06 are free. There are 6 days between these dates, but 4 business days.
how to calculate it in the database?
+3
source to share