title: Mysql query to convert total days to years, months and days
body: <p>I need to convert a total days to a years, months and days format using a mysql query.</p>
  
  <p>My current code its this one:</p>
  
  <pre><code>SELECT  nombre, fecha_de_inicio, DATEDIFF(NOW(), fecha_de_inicio) as days_employed
  FROM    cms_trabajadores 
  GROUP   BY days_employed desc
  </code></pre>
  
  <p>Right now the result its like this (3 columns):</p>
  
  <p>Name Started date and days_employed</p>
  
  <p>Aaron, 2007-06-25 00:00:00, 2759</p>
  
  <p>Where 1st column its name, 2nd column started date and 3rd and last column total worked days.</p>
  
  <p>I'm looking to have, total working days like:</p>
  
  <p>7 years, 6 months and 21 days</p>
  
  <p>Thanks in advance for your help.</p>
  
  <p>I do have the started date on my table and I'm always comparing vs the current day.</p>