title: How to convert Minutes to Hours Minutes and Seconds in SQL?
body: <p>Currently I am using this query, which gives me duration in minutes.</p>
  
  <p><strong>Part of My query</strong></p>
  
  <pre><code>Select 
     E.xyme
  
  From
      (SELECT Timee as xyme from  
              (select round(avg(tableT.DURATIONMIN),2) as Timee
                  FROM ownerName.tableT tableT
                     where tableT.FLAG = 0 )
      )E
  </code></pre>
  
  <p>Output would be</p>
  
  <pre><code>Xyme
  ----
  125.58
  </code></pre>
  
  <p><strong>Output Looking for</strong></p>
  
  <pre><code>Xyme
  ----
  2 hours, 5 minutes, 35 seconds
  </code></pre>
  
  <p><strong>Part solution</strong>
  I know we can use something like below but I am not able to implement.</p>
  
  <pre><code> floor((sysdate-Timee)*24)
    || ' HOURS ' ||
    mod(floor((sysdate-Timee)*24*60),60)
    || ' MINUTES ' ||
    mod(floor((sysdate-Timee)*24*60*60),60)
    || ' SECS ' Duration
  </code></pre>