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
Dec, 2004
Feb, 2004

I have used to_date(substr(accounting_date,-2)||substr(accounting_date,1,2),'MM-YY') query returns
1-Feb-2004
1-Dec-2004

Why I am getting DD?

Thanks.