title: Turn days into weeks, months, years.ORACLE
body: <p>I have this query and result:</p>
  
  <pre><code>SQL&gt; select AVG(SYSDATE - DOB) AS AVERAGE_AGE_IN_DAYS
    2  FROM MORTAL;
  
  AVERAGE_AGE_IN_DAYS
  -------------------
             17877.44
  </code></pre>
  
  <p>Is there a way to convert this to years, months, and days, within the same query?</p>