LocalDateTime - java.sql.Date in java 8?

Question

How to convert LocalDateTimeto java.sql.Datein java-8 ?

My search on the web basically gives me Timestamprelated code or LocalDateup java.sql.Date. I am looking LocalDateTimeup java.sql.Date.

Answer 1

There is no direct correlation between LocalDateTimeand java.sql.Date, since the previous one is a timestamp, and the last is a date.

However, there is a relationship between LocalDateand java.sql.Date, and the conversion can be performed as follows:

LocalDate date = //your local date
java.sql.Date sqlDate = java.sql.Date.valueOf(date)

Which for any given LocalDateTimegives you the following code:

LocalDateTime dateTime = // your ldt
java.sql.Date sqlDate = java.sql.Date.valueOf(dateTime.toLocalDate());

Answer 2

@M. , .

A java.sql.Date , . (, , ) , , a LocalDateTime java.sql.Date .

, :

LocalDateTime dt = // LocalDateTime value
// convert to Date (time information is lost)
java.sql.Date date = java.sql.Date.valueOf(dt.toLocalDate());

LocalDateTime , , :

LocalDateTime dt = // your LocalDateTime
// save time information (hour, minute, seconds, fraction of seconds)
LocalTime savedTime = dt.toLocalTime();
// convert to Date (time information is lost)
java.sql.Date date = java.sql.Date.valueOf(dt.toLocalDate());

// retrieve back the LocalDate (only day/month/year)
LocalDate localDate = date.toLocalDate();
// retrieve the LocalDateTime, with the original time values
LocalDateTime ldt = localDate.atTime(savedTime);

Answer 3

LocalDateTime java.sql.Date -

LocalDateTime dt = // your LocalDateTime
long epochMillis = dt.atZone(ZoneOffset.UTC).toInstant().toEpochMilli()
java.sql.Date date = new java.sql.Date(epochMillis);

java.sql.Date - , , , 1 1970 00: 00: 00.000 GMT, LocalDateTime.