title: How to get difference between two dates in Oracle and show it as ' x years y month z days'
body: <p>I need to calculate the difference between two dates in Oracle sql and show it in the following format: 'x years y months z days'.</p>
  
  <p>Now I see two ways to achieve this:</p>
  
  <p>The first way is to get the difference in days, and after that, bring it to 'x year y month z days'</p>
  
  <p>The second way is to extract years, month, and days with an extract function.</p>
  
  <p>In the first and second cases, I see problems on how to handle leap-year and difference in month with 30 days versus 31 days.</p>
  
  <p>Is there another, easier way to implement this?</p>