title: SQL time difference between two dates result in hh:mm:ss
body: <p>I am facing some difficulty with calculating the time difference between two dates.</p>
  
  <p>What I want is, I have two dates let say </p>
  
  <pre><code>@StartDate = '10/01/2012 08:40:18.000'
  @EndDate='10/04/2012 09:52:48.000'
  </code></pre>
  
  <p>so the difference between two dates in the form of <code>hh:mm:ss</code> is <code>72:42:30</code>. </p>
  
  <p>How can I get this result in a T-SQL query?</p>