Convert a varchar column to date for the month of December

Asked Dec 17 '21 at 05:38

Active Dec 17 '21 at 07:25

Viewed 25 times

I have a varchar2 column in a table which saves dates in it with the format mask 'DD-MON-RR'.

Now when I try to convert it with

{to_date(my_field,'DD-MON-RR')}

it returns accurate result except when I convert the December month, it throws an error

literal does not match the format string

I have solved my problem by converting whole string to {to_char} again, but my question is: why does Oracle not let me convert the month of December saved in form of 'DEC'?

edited Dec 17 '21 at 07:25

marc_s

732,580
175
1,330
1,459

asked Dec 17 '21 at 05:38

Abdul Mughees

What is the day component? Is it a number between 1 and 31? – Tim Biegeleisen Dec 17 '21 at 05:42
Please tag with the product in question; dates are handled quite differently in different products! – Rick James Dec 30 '21 at 00:18

Convert a varchar column to date for the month of December

0 Answers0