title: How to use years in a where statement to filter out time differences?
body: <p>So I am trying to select a list of Employees from a table named Employees, but only those who have been working at the company for 15 or more years. </p>
  
  <p>I am trying to work with the variable 'HireDate', and compare it with the current date, to see if the difference is greater than or equal to 15 years, however I dont know how to write "15 years" as a quantity, nor make this comparison. What I have written so far is this, but the last line is what I am unsure how to write. Anyone know how to go about this?</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT *
  FROM Employees
  WHERE DATEDIFF(year, DATE('now') , HireDate) &gt;=  15
  </code></pre>