SQL> INSERT INTO ONDUTY VALUES(
2 2010001,'2012-04-14 8:58:33','2012-04-14 17:01:20','N'
3 );
2010001,'2012-04-14 8:58:33','2012-04-14 17:01:20','N'
*
第 2 行出现错误:
ORA-01861: 文字与格式字符串不匹配
é¢ æ交ï¼
追çä¸æ交ï¼ä½ ä¹åçæå ¥ä¸ä¼çæï¼èä¸ä¼é表ï¼èªå·±å¤ççå°±ç¥éäº
追é®å¥½ 谢谢äºãã æåç¢ç£¨ä¸ä¸ã
谢谢 但是我还是不会
追答INSERT INTO ONDUTY VALUES(
'2010001',to_date('2012-04-14 8:58:33','yyy-MM-dd hh24:mi:ss'),to_date('2012-04-14 17:01:20','yyy-MM-dd hh24:mi:ss'),'N'
);
再试试