字符型中文日期怎么转换成日期型

Question

日期格式 11-10月-08 
SELECT to_date('11-10月-08','DD-Month-YY') FROM dual;
报错 ORA-01843: not a valid month
 server端字符集：
select userenv('language') from dual;
AMERICAN_AMERICA.AL32UTF8

Answer 1

SQL> SELECT to_date('11-10月-08','DD-Month-YY','nls_date_language=''SIMPLIFIED CHINESE''') sj FROM dual;

Answer 2

SELECT to_date('11-10-08','DD-Month-YY') FROM dual; SELECT to_date(repalce('11-10月-08','月',''),'DD-Month-YY') FROM dual; 

Answer 3

SELECT to_date(replace('11-10月-08','月',''),'DD-Month-YY') FROM dual;