问下各位~我执行一个insert语句到ORACLE10sql.append("INSERT INTO TB_USER_MST(USER_ID,USER_LOGIN,USER_NAME,USER_PASSWORD,USER_EMAIL,USER_GROUP_ID,USER_FLG,UPD_YMDHMS)VALUES(STGID_SEQ.NEXTVAL,'"+ub.getUserLogin()+"','"+ub.getUserName()+"','"+ub.getUserPassword()+"','"+ub.getUserEmail()+"','"+ub.getUserGroup()+"','"+ub.getUserFlag()+"','"+ymdhms+"')");
stmt.executeUpdate(sql.toString().trim());设置断点后,查看的值
 INSERT INTO TB_USER_MST(USER_ID,USER_LOGIN,USER_NAME,USER_PASSWORD,USER_EMAIL,USER_GROUP_ID,USER_FLG,UPD_YMDHMS)VALUES(STGID_SEQ.NEXTVAL,'254035318','1111111','1111111','1111111','0','0','2008-06-19 10:50:45.593')但是这个SQL语句在程序里不能executeupdate ,报这样的错误  ORA-01843: not a valid month
奇怪的是,我把这条SQL语句拿到ORACLE数据库里去编译却能插入~~~怎么回事啊??补充下:
ymdhms 是取得服务器当前时间~
java.util.Date currentTime = new java.util.Date();
Timestamp ymdhms = new Timestamp(currentTime.getTime());