Convert java.util.date to java.sql.Date

Question

With this line of code I can get through java.util.Date for java.sql.Date?

java.sql.Date sqlDate = java.sql.Date.valueOf(String.valueOf(date));

Taking into account that date this format :

Sat Jul 01 00:00:00 GMT+01:00 2017

Answer 1

If the variable date is a guy java.util.Date, just need:

java.sql.Date sqlDate = new java.sql.Date(date.getTime());

Now if you are going to convert a date in string to sql.Date, will only be possible if it is in format yyyy-[m]m-[d]d, where the month and day may contain only one digit if the second digit is zero, as in 2017-05-01, that can be passed as 2017-5-1.

However, if possible, I recommend using Joda Time making operations with dates and periods in time more flexible.

Reference:

• sql class documentation. Date