INSERT INTO "TRANS_PAT_REC" ( "INSURANCE_NO", "TRANS_ID", "INTERNAL_NO", "NAME", "TRANS_FLAG", "DELIVER_HOSPITAL",
"HOSPITAL_OR_CLINIC", "DELIVER_DATE", "DELIVER_CAUSE", "ORIGINAL_DIAGNOSIS", "ADMIT_HOSPITAL", "SPECIAL_FLAG", "IDENTITY_CLASS",
"OPERATOR" ) VALUES ( '600186196512010004', 1, '/', '肖青兰', 0, '600186', 1, TO_DATE('27-Jun-2007 15:57:30',
'DD-MON-YYYY HH24:MI:SS'), 'dddddd', '972.102', '600084', 0, '团以下干部', 'xiongy' )
Runtime error occurred: 1843 (ORA-01843: 无效的月份)
"HOSPITAL_OR_CLINIC", "DELIVER_DATE", "DELIVER_CAUSE", "ORIGINAL_DIAGNOSIS", "ADMIT_HOSPITAL", "SPECIAL_FLAG", "IDENTITY_CLASS",
"OPERATOR" ) VALUES ( '600186196512010004', 1, '/', '肖青兰', 0, '600186', 1, TO_DATE('27-Jun-2007 15:57:30',
'DD-MON-YYYY HH24:MI:SS'), 'dddddd', '972.102', '600084', 0, '团以下干部', 'xiongy' )
Runtime error occurred: 1843 (ORA-01843: 无效的月份)
alter session set nls_date_language='american' --以英语显示日期这样也应该可以
alter session set nls_date_language='american' --以英语显示日期这样也应该可以)TO:电脑重启之后alter session set nls_date_language='american' 参数又变回原来的了...(你插入数据的时候输入 '27-07-2007 15:57:30')
TO:SQL是程序运行的时候我用SQLMonitor跟出来的,程序我不能修改.