You can cut off the milliseconds using a Calendar: java.util.Date utilDate = new java.util.Date(); Calendar cal = Calendar.getInstance(); cal.setTime(utilDate); cal.set(Calendar.MILLISECOND, 0); System.out.println(new java.sql.Timestamp(utilDate.getTime())); System.out.println(new java.sql.Timestamp(cal.getTimeInMillis())); Output: 2014-04-04 10:10:17.78 2014-04-04 10:10:17.0
Is it possible that the date could actually be outside that range? Does it come from user input? If the answer to either of these questions is yes, then you should always check – otherwise you’re leaving your application prone to error. You can format your date for inclusion in an SQL statement rather easily: … Read more
The answer is really simple; import java.sql.Date; … LocalDate locald = LocalDate.of(1967, 06, 22); Date date = Date.valueOf(locald); // Magic happens here! r.setDateOfBirth(date); If you would want to convert it the other way around, you do it like this: Date date = r.getDate(); LocalDate localD = date.toLocalDate(); r is the record you’re using in JOOQ … Read more