a different TO_DATE behavior in 19c
Hello community.
Last month we upgraded oracle 12.2.0.1 to 19.2.0.0 on ExadataX7,
and found that a check condition of implicit format conversions of to_date has been somehow changed.
Please take a look at this.
*12.2.0.1
SQL> select TO_DATE('20190520','YYMMDD') from dual;
TO_DATE('20190520
-----------------
20190520 00:00:00
*19.2.0.0
SQL> select TO_DATE('20190520','YYMMDD') from dual;
select TO_DATE('20190520','YYMMDD') from dual
*
ERROR at line 1:
ORA-01843: not a valid month
I know that the code is not the way it should be, but this behavior is written in SQL reference manual as follows.
1