title: Subtract 1,000 years from a date
body: <p>We have records with dates far into the future (i.e. 3/9/3006) which are causing issues. Is there a way to update a date field to -1,000 years? Currently I have to look up the values of ten date fields in each record and then update each one like this. (This is Cerner CCL but you should be able to understand it). I can run PL/SQL in SQL Developer.</p>
  <p><code>set ACTIVE_STATUS_DT_TM = format(&quot;March 09, 2006 15:47:14&quot;, &quot;@LONGDATETIME&quot;)</code>
  <code>,ARRIVE_DT_TM = format(&quot;March 30, 2006 07:44:00&quot;, &quot;@LONGDATETIME&quot;)</code>
  <code>…</code></p>
  <p>I wasn't able to find anything in Oracle that would work like this:
  <code>ACTIVE_STATUS_DT_TM = ACTIVE_STATUS_DT_TM - 1000 years</code></p>
  <p>I tried this but it doesn't work:
  <code>set EST_ARRIVE_DT_TM = EST_ARRIVE_DT_TM - interval '1000' year</code></p>