【Oracle】Oracle 19c and Oracle 12c function TO_DATE is different
Oracle 19c and Oracle 12c function TO_DATE is different
Oracle 12c
SQL> select TO_DATE('20201120','YYMMDD') from dual;
-----------------
20-11-20
Oracle 19C
SQL> select TO_DATE('20201120','YYMMDD') from dual;
-----------------
ORA-01843: 指定した月が無効です。
01843. 00000 - "not a valid month"
*Cause:
*Action:
↓
Correct:
->SQL> select TO_DATE('20201120','YYYYMMDD') from dual;
-----------------
20-11-20
--*--
Leave a Comment