Return to Snippet

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