Tag Archives: ORA01843: not a valid month

Oracle Error: ORA-01843: not a valid month [Solved]

Client: select * from sys.nls_session_parameters;
server: select * from sys.nls_database_parameters;

Error in executing script: ora-01843: not a valid month
confirmation problem: client NLS_date_Language is American
solution: modify NLS_date_The language parameter is Chinese. Data such as’ November may – 18 10.56.50.139000 am ‘is successfully imported
— this command is only useful for the current session
alter session set NLS_date_language=’SIMPLIFIED CHINESE’;