oracle

insert into TBL_Message(id,message,author,postTime) values('TBL_Message_seq.nextval','你好我做第九章啦','zhaojw',to_char('sysdate','YYYY"年"MM"月"DD"日"HH"时"MI"分"SS"秒"'));
有什么问题呢？？？

如果postTime是date类型，改成下面的sql
[code="sql"]INSERT INTO TBL_Message
(id,
message,
author,
postTime)
VALUES
(TBL_Message_seq.NEXTVAL,
'?好我做第九章? ',
'zhaojw',
SYSDATE);[/code]

[code="sql"]
INSERT INTO TBL_Message
(id,
message,
author,
postTime)
VALUES
(TBL_Message_seq.NEXTVAL,
'?好我做第九章? ',
'zhaojw',
to_char('sysdate', 'YYYY"年"MM"月"DD"日"HH"时"MI"分"SS"秒"'));
[/code]

改下
[code="sql"]
INSERT INTO TBL_Message
(id,
message,
author,
postTime)
VALUES
(TBL_Message_seq.NEXTVAL,
'?好我做第九章? ',
'zhaojw',
to_char(SYSDATE,'YYYY"年"MM"月"DD"日"HH"时"MI"分"SS"秒"'));
[/code]

表的postTime是什么类型？varchar2还是date