title: converting secondcolumn value(minutes) to hour:minutes:second using sql
body: <p>I have query like this:</p>
  
  <p>First query:</p>
  
  <pre><code>SELECT* FROM Transaction_tbl WHERE Locid=6 AND Paydate is not null
  </code></pre>
  
  <p>Second query:</p>
  
  <pre><code>SELECT SUM(DATEDIFF(MI,t.Paydate,t.DelDate)) as Totalv , 
      AVG( CONVERT(NUMERIC(18,2), DATEDIFF(MI,t.Paydate,t.DelDate))) as Average
  FROM Transaction_tbl t 
  WHERE Locid=6
  </code></pre>
  
  <p>my output:</p>
  
  <pre><code>Totalv | Average
  -------+-----------
  33169  | 1745.736842
  </code></pre>
  
  <p>But i want to get <code>average</code> in <code>hour:minutes:second</code>, is there any way to get average in hh:mm:ss format.</p>