Under Linux linked oracle12c executable code at the bottom of an error, don't know what the DBA set up, depressed!!!!! O great god teach
The select to_date (' 20190528 ', 'YYMMDD) from dual;

Ora - 01843 specified is invalid

CodePudding user response:

The select to_date (' 20110528 ', 'YYMMDD) from dual;
The above statement, there is no problem, try the third four less than 12 more than 00, there is no problem

CodePudding user response:

Show parameter NLS;

Look at the parameter configuration,

CodePudding user response:

NLS_DATE_FORMAT
The RR - MM - DD

CodePudding user response:

Should not be YYYYMMDD