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);

上一篇 下一篇

猜你喜欢

热点阅读