那位大哥帮我看看这个语句有什么问题啊,执行时报错:
INSERT INTO topic(id,parentid,forumid,username,title,content,postdate,replies) VALUES
(1,0,1,'admin','jsp学习','jsp学习内容',to_date('2008-11-04 20:29:55','YYYY-MM-DD HH:MM:SS'),1)
ORA-01810: 格式代码出现两次
INSERT INTO topic(id,parentid,forumid,username,title,content,postdate,replies) VALUES
(1,0,1,'admin','jsp学习','jsp学习内容',to_date('2008-11-04 20:29:55','YYYY-MM-DD HH:MM:SS'),1)
ORA-01810: 格式代码出现两次
INSERT INTO topic(id,parentid,forumid,username,title,content,postdate,replies) VALUES
(1,0,1,'admin','jsp学习','jsp学习内容',to_date('2008-11-04 20:29:55','YYYY-MM-DD HH:MM:SS'),1)
'YYYY-MM-DD HH:MM:SS'
-->
'YYYY-MM-DD HH24:MI:SS'
INSERT INTO topic
(id, parentid, forumid, username, title, content, postdate, replies)
VALUES
(1,
0,
1,
'admin',
'jsp学习',
'jsp学习内容',
to_date('2008-11-04 20:29:55', 'YYYY-MM-DD HH24:MI:SS'),
1);