Java – How to convert java.util.Date to java.sql.Date and vice-versa ?

January 14, 2023 SJ Java 8 Date/Time 0

In this article, we will discuss how to convert java.util.Date to java.sql.Date and vice-versa

1. java.util.Date class :

  • Date class introduced in Java 1.0 version
  • Implements Serializable, Cloneable and Comparable interfaces
  • To work with new Joda Date/Time API introduced in Java 1.8 version, it provides below methods
    1. from(Instant)
    2. toInstant()
  • Since Java 1.2 version, Date class has compareTo() method to compare 2 Date objects
  • If the comparison of date1.compareTo(date2) method returns,
    1. positive (1) then date1 is greater/future date when comparing with date2
    2. negative (-1) then date1 is lesser/past date when comparing with date2
    3. zero (0) then date1 is equal/same date when comparing with date2

2. java.sql.Date class :

  • java.sql.Date class introduced in Java 1.1 version
  • java.sql.Date is the sub–class of java.util.Date which is mainly used for JDBC database operations
  • java.sql.Date class represents only Date part whereas java.util.Date represents both Date & Time parts starting from January 1, 1970 00:00:00.000 GMT in milliseconds

3. java.util.Date to java.sql.Date conversion :

  • First, create instance of java.util.Date which returns current Date & Time along with Day
  • To convert java.util.Date to java.sql.Date, instantiate java.sql.Date and pass above created java.util.Date as constructor–argument in milliseconds

ConvertJavaUtilDateToJavaSqlDate.java

package in.bench.resources.date.comparison;

import java.util.Date;

public class ConvertJavaUtilDateToJavaSqlDate {

	public static void main(String[] args) {

		// current date
		Date date = new Date();
		System.out.println("Current Util Date :- \n" + date);


		// convert to java.sql.Date
		java.sql.Date sqlDate = new java.sql.Date(date.getTime()); // constructor-arg
		System.out.print("\nCurrent SQL Date :- \n" + sqlDate);
	}
}

Output :

Current Util Date :- 
Thu Jan 12 16:15:21 IST 2023

Current SQL Date :- 
2023-01-12

4. java.sql.Date to java.util.Date conversion :

  • First, get current time in milliseconds using System.currentTimeMillis();
  • Instantiate java.sql.Date passing above obtained current time in milliseconds as constructor–argument
  • To convert java.sql.Date to java.util.Date, instantiate java.util.Date and pass java.sql.Date in milliseconds using getTime() method as constructor–argument

ConvertJavaSqlDateToJavaUtilDate.java

package in.bench.resources.date.comparison;

import java.util.Date;

public class ConvertJavaSqlDateToJavaUtilDate {

	public static void main(String[] args) {

		// current time in milliseconds
		long currentTimeMillis = System.currentTimeMillis(); // time in millis


		// current SQL Date
		java.sql.Date sqlDate = new java.sql.Date(currentTimeMillis); // constructor-arg
		System.out.println("Current SQL Date :- \n" + sqlDate);


		// current date
		Date date = new Date(sqlDate.getTime());
		System.out.print("\nCurrent Util Date :- \n" + date);
	}
}

Output :

Current SQL Date :- 
2023-01-12

Current Util Date :- 
Thu Jan 12 16:18:44 IST 2023

Related Articles :

References :

Happy Coding !!
Happy Learning !!

Java – How to compare 2 Date instances using Date.compareTo() method ?

Related posts:

  1. Java 8 – How to convert java.util.Date to LocalTime in different ways ?
  2. Java 8 – How to convert LocalDate to java.util.Calendar and vice-versa ?
  3. Java 8 – How to convert java.util.Date to an OffsetDateTime in different ways ?
  4. Java 8 – How to convert OffsetDateTime to java.util.Date and vice-versa ?