title: Create a Select statement that determines a duration between 2 dates split out to each of the 2 dates
body: <p>I have a table with records that contain the following columns: 
  Taskname, Start_Date, End_Date</p>
  
  <p>I need to add a new column that shows the Duration between Start_Date and End_Date.
  If a tasks overlaps multiple days I would need to create a split of duration for each of the dates</p>
  
  <p>Example:</p>
  
  <p>Start_Date = 4-6-2020 23:45:00 End date = 5-6-2020 00:00:16</p>
  
  <p>Results 2 records showing the duration for each of the days:</p>
  
  <pre><code>4-6-2020   15
  5-6-2020   16
  </code></pre>
  
  <p>Thank you for looking at my question</p>