Absences Report

Summary

get the working dates between start_date and end_date

Content

we have requiremnet to generate absences report, need help on sql query,
 
 If any empployee having absence start date as 01-oct-2018 and end date is 08-oct-2018
 
 output should be like below. as 06-oct-2018, 07-oct-2018 weekends( saturday and sunday) should not include in output
 
 start date        end date             hours
 01-oct-2018   01-oct-2018           8
 02-oct-2018   02-oct-2018           8 
 03-oct-2018   03-oct-2018           8
 04-oct-2018   04-oct-2018           8
 05-oct-2018   05-oct-2018           8
 08-oct-2018   08-oct-2018           8