Posted By

rengber on 09/25/07


Tagged

Oracle PLSQL DateTime


Versions (?)

Simple Technique to Subtract Years from an Oracle Date


 / Published in: SQL
 

  1. to_number(to_char(sysdate,'YYYYMMDD'),'99999999')-50000)
  2. --subtracts 5 years from a date.
  3. -- 20070924
  4. -- -50000
  5. -- =20020924

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: xer0x on January 24, 2008

--Yet another method to do the same thing: sysdate - interval '5' year

i find this a little easier to read..

You need to login to post a comment.