title: How to calculate age (in years) based on Date of Birth and getDate()
body: <p>I have a table listing people along with their date of birth (currently a nvarchar(25))</p>
  
  <p>How can I convert that to a date, and then calculate their age in years?</p>
  
  <p>My data looks as follows</p>
  
  <pre><code>ID    Name   DOB
  1     John   1992-01-09 00:00:00
  2     Sally  1959-05-20 00:00:00
  </code></pre>
  
  <p>I would like to see:</p>
  
  <pre><code>ID    Name   AGE  DOB
  1     John   17   1992-01-09 00:00:00
  2     Sally  50   1959-05-20 00:00:00
  </code></pre>