ORA-01843: invalid month
Execute select months_between ('29murmur2008 hybrid 2008') from dual in PLSQL Developer to report error.
SQL > select months_between ('29 words Martel 2008') from dual
Select months_between ('29murafure 2008) from dual (' 29murmur2008')
ORA-01843: invalid month
The execution of select months_between in the sqlplus of the oracle server ('29murmarly2008') from dual was successful.
Solution: unify the language of the client date
Method 1: unify Chinese
SELECT TO_DATE ('21-May-2014') FROM dual
Method 2: unify English
1. The language for modifying the date of a client session: ALTER SESSION SET nls_date_language='american'
2. Successful execution: SELECT TO_DATE ('21murMai2014') FROM dual
