title: SQL Query for those people who turned 18 from today's date
body: <p>I am new to SQL and am trying to write a query that returns those contacts who have turned 18 based on the current date (today). I thought about the query below but I am unsure how to add the part where 'and date equals today'.</p>
  
  <p>I appreciate that I am probably making it more complicated than it needs to be.</p>
  
  <pre><code>    SELECT date_of_birth 
      FROM contacts
      WHERE ((DATEDIFF(Year,date_of_birth,GETDATE())&gt;'17') AND 
  (DATEDIFF(Year,date_of_birth,GETDATE())&lt;'19')) 
  </code></pre>
  
  <p>date_of_birth is greater than 17 but less than 19 </p>