Simple Technique to Subtract Years from an Oracle Date

Revision: 3870

at September 25, 2007 20:07 by rengber

Initial Code

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

Initial URL

Initial Description

Initial Title

Simple Technique to Subtract Years from an Oracle Date

Initial Tags

Oracle

Initial Language

SQL