title: What is wrong with my Oracle 10gr2 check constraint? Trying to enforce a date range
body: <p>I want to enforce CHECK constraint on a date range such that all dates in column BIRTH_DATE are less than tomorrow and greater than or equal to 100 years ago.  I tried this expression in a CHECK constraint:</p>
  
  <pre><code>BIRTH_DATE &gt;= (sysdate - numtoyminterval(100, 'YEAR')) AND BIRTH_DATE &lt; sysdate + 1
  </code></pre>
  
  <p>But I received the error "ORA-02436: date or system variable wrongly specified in CHECK constraint"</p>
  
  <p>Is there a way to accomplish this using a CHECK constraint instead of a trigger?</p>