title: Calculating age derived from current date and DOB
body: <p>I'm trying to calculate the age of a user based on the current year and his year of birth, but something in my syntax appears to be incorrect and I can't spot it.</p>
  
  <pre><code>CREATE TABLE Normal_Users(
  
  first_name varchar(20),
  last_name varchar(20),
  date_of_birth date,
  age int = year(CURRENT_TIMESTAMP) - year(date_of_birth) 
  )
  </code></pre>
  
  <p>Why is this incorrect?</p>