/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
to_number(to_char(sysdate,'YYYYMMDD'),'99999999')-50000) --subtracts 5 years from a date. -- 20070924 -- -50000 -- =20020924