How to convert LocalDate to SQL Date Java?

by

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 and .getDate() is the method for getting the date out of your record; let’s say you have a date column called date_of_birth, then your get method should be called getDateOfBirth().

More Related Contents:

  1. How to parse/format dates with LocalDateTime? (Java 8)
  2. JSON Java 8 LocalDateTime format in Spring Boot
  3. UnsupportedTemporalTypeException when formatting Instant to String
  4. Difference between year-of-era and week-based-year?
  5. Any difference between java.time.Clock.systemDefaultZone().getZone() vs java.util.TimeZone.getDefault().toZoneId()?
  6. Convert java.time.LocalDate into java.util.Date type
  7. How to get milliseconds from LocalDateTime in Java 8
  8. cannot resolve symbol ‘java.time.LocalDate’ error in android studio
  9. JPA support for Java 8 new date and time API
  10. Unit testing a class with a Java 8 Clock
  11. Differences between Java 8 Date Time API (java.time) and Joda-Time
  12. Unable to obtain ZonedDateTime from TemporalAccessor using DateTimeFormatter and ZonedDateTime in Java 8
  13. How can I mock java.time.LocalDate.now()
  14. Mocking time in Java 8’s java.time API
  15. Convert between LocalDate and sql.Date [duplicate]
  16. Why does the new Java 8 Date Time API not have nanosecond precision? [duplicate]
  17. Can’t parse String to LocalDate (Java 8)
  18. DateTimeFormatter month pattern letter “L” fails
  19. Formatting a Duration in Java 8 / jsr310
  20. How to extract epoch from LocalDate and LocalDateTime?
  21. Unable to obtain OffsetDateTime from TemporalAccessor
  22. How can I parse/format dates with LocalDateTime? (Java 8)
  23. LocalDate to java.util.Date and vice versa simplest conversion? [duplicate]
  24. Get original pattern String given a JDK 8 DateTimeFormatter?
  25. How to set format of string for java.time.Instant using objectMapper?
  26. String to ZonedDateTime is changing format
  27. DateTimeFormatter Support for Single Digit Day of Month and Month of Year
  28. Java 8 LocalDate – How do I get all dates between two dates?
  29. What is the motivation for two different week-based-year definitions in JSR-310?
  30. What’s the difference between ZonedDateTime and OffsetDateTime?

Leave a Comment