Get the Date time between two dates.

Jan 12 2018 5:14 AM

I have two dates like '01-14-18 09:00:00 PM' and 01-15-18 08:30:00 AM

Now I want to get the table with columns like

DayName StartTime EndTime

Sunday 09:00:00 23.59.59

MonDay 00:00:00 08.30.00

Means I want a total time in each day.

Please, guys, help me.

Answers (2)