Oracle时间精确到时、分、秒处理方法
StringBuffer sqlBuffer = new StringBuffer();sqlBuffer.append("INSERT INTO T_TRUST_USER (CENT_ID,CUSER_ID,");sqlBuffer.append("CCREATOR_USER_ID,CCREATE_DATE");sqlBuffer.append(") values (?,?,?,");sqlBuffer.append("to_date('");sqlBuffer.append(sdf.format(createDate));sqlBuffer.append("','yyyy-MM-dd HH24:mi:ss'))");Object[] params = new Object[] { entId, userId, creatorId };result = jdbcTemplate.update(sqlBuffer.toString(), params);
参考:
Oracle时间精确到时、分、秒处理方法