title: How to calculate age based on date of birth in mysql?
body: <p>My date of birth format is : <strong>2017-Feb-15</strong></p>
  
  <p>when I am using the following query, it's not working</p>
  
  <pre><code>select (year(current_date)-year(dob)) as age from user 
  </code></pre>
  
  <p>or how to current <strong>2017-Feb-15</strong> into <strong>2017-02-15</strong> format</p>