mysql set 时间数据
2019-11-15 本文已影响0人
S等价交换S
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd");
String nowDate = sdf.format(new Date());
java.sql.Timestamp create_date = null;
java.sql.Date effective_date2 = null;
try {
registrant_date_finish2 = new java.sql.Date(sdf2.parse(registrant_date_finish).getTime());
} catch (ParseException e) {
registrant_date_finish2 = null;
}
try {
create_date = new java.sql.Timestamp(sdf.parse(nowDate).getTime());
} catch (ParseException e) {
create_date = null;
}
psmt.setDate(12, registrant_date_finish2);
psmt.setTimestamp(13, create_date);