title: Subtracting 30 Years from Current Date in Oracle SQL
body: <p>I need to write a query in which I select all people who have a date of birth over 30 years ago. Unfortunately, as I am using Oracle I cannot use the <code>DATEADD()</code> function.</p>
  
  <p>I have currently got this, but obviously this isn't dynamic and won't change as the years pass:</p>
  
  <pre><code>SELECT Name, DOB
  FROM Employee
  WHERE DOB &lt;= DATE '1985-01-01';
  </code></pre>