title: SQL query to find out experience of employee in the format 'yy years mm months dd days'
body: <p>I want a query to find out experience of employee in the format 'yy years mm months dd days'. </p>
  
  <pre><code>SELECT EMPID, EMPNAME, DEPARTMENT, DESIGNATION, DATEDIFF(YEAR, DOJ, GETDATE()) AS EXPERIENCE, 
         EMPSTATUS AS JOB_STATUS 
  FROM EMPLOYEE
  </code></pre>
  
  <p>DOJ - field in db for saving 'date of joining' of employee. 
  This is the query which returns experience in years only. How to modify it?</p>