title: Convert Days to Years as in following format?
body: <p>How to convert 1701 days to 4.660 years...</p>
  
  <p>I used this following query but i get only Year .... </p>
  
  <p>My query:</p>
  
  <pre><code>SELECT DATEDIFF(YEAR , B.emp_join_date, GETDATE())  from employee B
  </code></pre>
  
  <p>Output I get:</p>
  
  <pre><code>4
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>4.660 
  </code></pre>
  
  <p>How i get the result?</p>