title: date time difference get hour:minutes:seconds
body: <p>I have query like this:</p>
  
  <pre><code>select t.Paydate,t.DelDate,DATEDIFF(MI, t.Paydate,t.DelDate) as Datdiffernce 
  from Transaction_tbl t 
  where t.transactID=19
  </code></pre>
  
  <p>I am getting out put like this:</p>
  
  <pre><code>Paydate                 DelDate                 Datdiffernce
  ----------------------- ----------------------- ------------
  2013-05-07 18:36:50.000 2013-05-07 18:58:32.000     22
  </code></pre>
  
  <p><code>Datedifference</code> am getting only 22 mints. </p>
  
  <p>Instead of getting that how I can get date difference in this format <code>hh:mm:ss</code>?</p>