con = ConnectionPool.getInstance().getConnection();
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.SSS");
String ti = sf.format(new Date());
String sql = "update ngtc_consign_batch set fetchDate = '"+ti+"' where batchid in (" + Ids.toString() + ")";
log.info(sql);
pStmt = con.createStatement();
pStmt.executeUpdate(sql);
就因为MM被我写成了mm,调了半天,才把毛病找出来,要不就一直报
“从 char 数据类型到 datetime 数据类型的转换导致 datetime 值越界”错误