oracle ORA-01843

 oracle ORA-01843

https://nknuahuang.wordpress.com/2018/09/04/oracleinser%E8%B3%87%E6%96%99%E7%99%BC%E7%94%9Fora-01843%E7%9A%84%E9%8C%AF%E8%AA%A4/

檢查服務器編碼:

執行SQL語法:

select * from v$nls_parameters; 

在 to_date ,to_timestamp
加上

'NLS_DATE_LANGUAGE = AMERICAN'

'TRADITIONAL CHINESE'

to_timestamp('15-JAN-21 12.07.09.224198000 PM','DD-MON-RR HH.MI.SSXFF AM','NLS_DATE_LANGUAGE = AMERICAN')