JDBC - How to Convert java.sql.Date to java.util.Date in Java with Example (original) (raw)

How to convert java.sql.Date into a java.util.Date and vice-versa is a popular JDBC interview question which is also asked a follow-up question of the difference between java.sql.Date and java.util.The date which we have seen in our last article. Since both SQL date and Util date store values as a long millisecond, converting them back and forth is easy. Both java.sql.Date and java.util.The date provides a convenient method called getTime() which returns a long millisecond equivalent of a wrapped date value. Here is a quick example of converting java.util.Date to java.sql.Date and then back to util Date.

Java Example to convert java.sql.Date to java.util.Date

As stated above, we have used the getTime() method in this example to transfer long millisecond values from one Date type, java.sql.Date to another like the java.util.Date, to convert SQL Date into util Date. You can further see these free JDBC courses to learn more about the Date and time data types in JDBC and Java.

public class DateConverter {

public static void main(String args[]) throws InterruptedException {

//creating instances of java.util.Date which represents today's date and time
java.util.Date now = new java.util.Date();
System.out.println("Value of java.util.Date : " + now);

//converting java.util.Date to java.sql.Date in Java
java.sql.Date sqlDate = new java.sql.Date(now.getTime());
System.out.println("Converted value of java.sql.Date : " + sqlDate);

//converting java.sql.Date to java.util.Date back
java.util.Date utilDate = new java.util.Date(sqlDate.getTime());
System.out.println("Converted value of java.util.Date : " + utilDate);
}

}

Output:
Value of java.util.Date : Tue Apr 10 00:12:18 VET 2012
Converted value of java.sql.Date : 2012-04-10
Converted value of java.util.Date : Tue Apr 10 00:12:18 VET 2012

That's all on how to convert java.sql.Date into a java.util.Date in Java. As you have seen, it's pretty easy to convert them by using the getTime() method. There is another way to convert them using the String value of one Date and then converting String to java.util.Date but that's not recommended, and using getTime() is more convenient than that.

Other JDBC tutorials for Java programmer