I want to update one date column in oracle table for the below scenario...
- currentYR=Get the Current Year from the SYSDATE (2015)
- currentYR=currentYR-2(2013)
- Need to set date field like 01-JUN-13(Last TWO DIGITS OF currentYR(2013)
Basically i just want to set set date like year=2 years earlier from sysdate and month=june,date=1. and date format is like DD-MON-YY(01-JUN-13)
Please guide me to resolve this problem.
Based on the comment above I think you would like to set the value of the column to a date where only the last two digits of the year are provided. You can do so by using a Datetime format model reflecting this: