Getting the date from a ResultSet for use with java.time classes

by

Most database vendors don’t support JDBC 4.2 yet. This specification says that the new java.time-types like LocalDate will/should be supported using the existing methods setObject(...) and getObject(). No explicit conversion is required and offered (no API-change).

A workaround for the missing support can be manual conversion as described on the Derby-mailing list.

Something like:

LocalDate birthDate = resultSet.getDate("birth_date").toLocalDate();

As you can see, these conversions use the non-deprecated types java.sql.Date etc., see also the javadoc.

More Related Contents:

  1. What is the difference between year and year-of-era?
  2. Is there a class in java.time comparable to the Joda-Time Interval?
  3. Is Joda Time deprecated with java 8 Date and Time API? (java.time)
  4. LocalDateTime to java.sql.Date in java 8?
  5. Issue with DateTimeParseException when using STRICT resolver style
  6. How to parse/format dates with LocalDateTime? (Java 8)
  7. Difference between year-of-era and week-based-year?
  8. Any difference between java.time.Clock.systemDefaultZone().getZone() vs java.util.TimeZone.getDefault().toZoneId()?
  9. How to get milliseconds from LocalDateTime in Java 8
  10. JPA support for Java 8 new date and time API
  11. JDK dateformatter parsing DayOfWeek in German locale, java8 vs java9
  12. Unit testing a class with a Java 8 Clock
  13. How can I create a Java 8 LocalDate from a long Epoch time in Milliseconds?
  14. Differences between Java 8 Date Time API (java.time) and Joda-Time
  15. Unable to obtain ZonedDateTime from TemporalAccessor using DateTimeFormatter and ZonedDateTime in Java 8
  16. Mocking time in Java 8’s java.time API
  17. Convert between LocalDate and sql.Date [duplicate]
  18. Why can’t I get a duration in minutes or hours in java.time?
  19. How to extract epoch from LocalDate and LocalDateTime?
  20. How can I parse/format dates with LocalDateTime? (Java 8)
  21. Why does Java8 Stream generate nothing?
  22. Get original pattern String given a JDK 8 DateTimeFormatter?
  23. How to set format of string for java.time.Instant using objectMapper?
  24. DateTimeFormatter Support for Single Digit Day of Month and Month of Year
  25. Java 8 LocalDate – How do I get all dates between two dates?
  26. Problem with parse a LocalDateTime using java 8
  27. Persist java.time.Instant (JDK8) with JPA2/Hibernate
  28. Java 8 stream emitting a stream
  29. When is a Java Class loaded?
  30. What’s the difference between ZonedDateTime and OffsetDateTime?

Leave a Comment