插入语句时出现的时间 问题。

popo_b

我在用insert语句插入一条记录时，出现了ORA-01855 AM/A.M. or PM/P.M. required的错误，

而且我在网上找到了错误的原因
Cause:  A date specification contained a meridian indicator format code but a valid meridian indicator was not specified. If a meridian indicator code, A.M./P.M. or AM/PM, is included in a date format, the date must include a valid meridian indicator.  

Action:  Specify the meridian indicator in the correct format, A.M./AM or P.M./PM.  


我的insert 语句 是
INSERT INTO KEYWORD ( KEYWORDNAME, EXPIREDDATE, EXPIREDRETURN, ATTACHMENT) VALUES ('LOCKVGSMZ', TO_Date('10/26/2003 11:08:20 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'Sorry, the keyword has expired.', NULL)
我看to_date函数没有错啊。
请高手帮我一下啦。

popo_b

没有高手能指点二下吗。

ximcn

换成 hh24的模式