【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

--*--

No comments

Powered by Blogger.