title: Calculate exact date difference in years using SQL
body: <p>I receive reports in which the data is <code>ETL</code> to the DB automatically.  I extract and transform some of that data to load it somewhere else.  One thing I need to do is a <code>DATEDIFF</code> but the year needs to be exact (i.e., 4.6 years instead of rounding up to five years.</p>
  
  <p>The following is my script:</p>
  
  <pre><code>select *, DATEDIFF (yy, Begin_date, GETDATE()) AS 'Age in Years'
  from Report_Stage;
  </code></pre>
  
  <p>The <code>'Age_In_Years'</code> column is being rounded.  How do I get the exact date in years?</p>