Perhaps this is possible with a cross join, but I haven't been able to figure it out.
I have data that includes a start-time and an end-time that could span multiple days. I would like to divide up the time interval to only see hours of the interval relevant to a particular day or week.
For example: StartTime = 4/15/2016 7:00 AM
EndTime = 8/16/2016 6:00 AM
How can I see the hours/days from this time interval distributed over individual days/weeks? For instance, only the week of 6/19/2016?
Thanks for any and all assistance.
datediff('hour', [Start Time], [end Time]) this gives you the hours between 2 dates,