How to convert java.util.Date to java.sql.Date keeping up hours, minutes and seconds?

Question

I am doing a program in Java. In it I get a date of type java.util.Date, but I need it in java.sql.Date so that I can enter into the database. But on that date, I have hour, minute and second and I would like to insert with all this data. Someone knows how to do it?

Thank you.

Answer 1

To convert from java.util.Date for java.sql.Date:

java.util.Date a = ...;
java.sql.Date b = new java.sql.Date(a.getTime());

To insert date and time, use the class java.sql.Timestamp:

java.util.Date a = ...;
java.sql.Timestamp b = new java.sql.Timestamp(a.getTime());

You can use a Timestamp with a PreparedStatement in the method setTimestamp(int, Timestamp). To get one of those from a ResultSet, use the method getTimestamp(int) or the method getTimestamp(String).