title: How to calculate age (in years) based on Date of Birth in SQL
body: <p>I want to  get the  1st of the month following the date the person turns 70. How to achive this in SQL</p>
  
  <p>i am calculating age using the formula</p>
  
  <pre><code>DECLARE @Date_of_birth DATETIME = '1915-10-02 00:00:00.000'
  DECLARE @AGE INT
  SELECT @AGE =  FLOOR((CAST (GETDATE() AS INTEGER) - CAST(@Date_of_birth AS INTEGER)) / 365.25) 
  
  IF(@AGE &gt; 70)
  
     How to find the first of the month following the date ??
  IF (@AGE &gt;80)
  </code></pre>