title: DateDiff years into decimals
body: <p>I have two dates in which i would like to find the number of years between them, however i would need to show the value to two decimal places.  I have tried the following but i always get a value returned of 0 as all of my dates do not cover a whole year:</p>
  
  <pre><code>DATEDIFF(yy, @EndDateTime, i.mat_exp_dte)
  </code></pre>
  
  <p>I have then tried finding the number of days between the two and then dividing it by 365, but this still returns 0:</p>
  
  <pre><code>DATEDIFF(dd, @EndDateTime, i.mat_exp_dte)/365
  </code></pre>
  
  <p>Am confused now as to how to calculate this.  Would i need to convert the DataDiff into a different data type?</p>