I have a column accounting_date varchar2(4) and populated with the value 0412,0402 etc. I need to convert it as a date like first two digits are year and last two digits are Month. the format I am looking is
I have used to_date(substr(accounting_date,-2)||substr(accounting_date,1,2),'MM-YY') query returns
Why I am getting DD?