ORA-01858: a non-numeric character was,to_date問題

ORA-01858: a non-numeric character was found where a numeric was expected

 

这个问题是由于

Date dateCreated = startBookForm.getDateCreated();//录入日期

String dateCreatedStr = "to_date('"+dateCreated+"','yyyy-mm-dd HH24:MI:SS')";



pstmt.setString(5, dateCreatedstr);//传递日期类型的时候用了String

 

改成下面这样就好了

 

Date dateCreated = startBookForm.getDateCreated();//录入日期



pstmt.setDate(5, dateCreated);//传递日期类型时需要setDate

 

黑色头发  http://heisetoufa.iteye.com