How to convert localDatetime to sql date time

Question

I have a table with a DateTime column. In java, I get localDatetime (now):

DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd HH:mm:ss");
LocalDateTime now = LocalDateTime.now();
System.out.println(dtf.format(now));

i want to format this to sql Datetime to insert into MySQL. Thank you!

score -2 · Answer 1 · answered Aug 14 '17 at 13:19

-2

You need to convert the LocalDateTime into milliseconds and create java.sql.date object from it, e.g.:

LocalDateTime now = LocalDateTime.now();
long millis = now.toInstant(ZoneOffset.ofTotalSeconds(0)).toEpochMilli();
Date date = new Date(millis);

answered Aug 14 '17 at 13:19

Darshan Mehta

30,102
11
68
102

@downvoter care to explain? – Darshan Mehta Aug 14 '17 at 13:48
upvoted. but how to convert to sql datetime? That was OP's question. I guess that was why you were downvoted. – likejudo Apr 01 '20 at 23:32

How to convert localDatetime to sql date time

1 Answers1