Difference Between java.sql.Time, java.sql.Timestamp and java.sql.Date in Java

In Java, handling date and time information accurately is essential for many applications, particularly those involving database interactions. The java.sql package provides three key classes java.sql.Date, java.sql.Time, and java.sql.Timestamp designed to map SQL standard date and time types to Java objects.

Each class serves a distinct purpose and offers specific functionalities: java.sql.Date handles date-only values, java.sql.Time manages time-only values, and java.sql.Timestamp deals with date and time values, including nanoseconds. Understanding the differences between these classes is crucial for developers to ensure proper data handling, precise storage, and retrieval from SQL databases.

java.sql.Date

Purpose: Represents a date (year, month, day) without a time component.
Corresponding SQL Type: DATE.
Precision: Stores date information to the precision of days.
Internal Storage: Internally stores the date as milliseconds since January 1, 1970, 00:00:00 GMT, but the time components (hours, minutes, seconds, milliseconds) are set to zero.
Example Output: 2024-07-08.

java.sql.Time

Purpose: Represents a time (hours, minutes, seconds) without a date component.
Corresponding SQL Type: TIME.
Precision: Stores time information to the precision of seconds.
Internal Storage: Internally stores the time as milliseconds since January 1, 1970, 00:00:00 GMT, with the date components (year, month, day) set to the epoch date (1970-01-01).
Example Output: 15:23:01.

java.sql.Timestamp

Purpose: Represents both date and time, with optional nanosecond precision.
Corresponding SQL Type: TIMESTAMP.
Precision: Stores date and time information to the precision of nanoseconds.
Internal Storage: Internally stores the date and time as milliseconds since January 1, 1970, 00:00:00 GMT, with an additional field for nanoseconds.
Example Output: 2024-07-08 15:23:01.123456789.

Feature	java.sql.Date	java.sql.Time	java.sql.Timestamp
Purpose	Represents a date without time	Represents a time without date	Represents both date and time
Corresponding SQL Type	DATE	TIME	TIMESTAMP
Precision	Days	Seconds	Nanoseconds
Internal Storage	Stores date as milliseconds since January 1, 1970, 00:00:00 GMT (time components set to zero)	Stores time as milliseconds since January 1, 1970, 00:00:00 GMT (date components set to epoch date 1970-01-01)	Stores date and time as milliseconds since January 1, 1970, 00:00:00 GMT, with an additional field for nanoseconds
Usage in JDBC	Used to interact with SQL DATE columns	Used to interact with SQL TIME columns	Used to interact with SQL TIMESTAMP columns
Constructor Parameters	long (milliseconds) or String (date)	long (milliseconds) or String (time)	long (milliseconds) or String (timestamp)
Inheritance	Extends java.util.Date	Extends java.util.Date	Extends java.util.Date

Examples

File Name: SqlDateExample.java

import java.sql.Date;
public class SqlDateExample {
    public static void main(String[] args) {
        Date sqlDate = new Date(System.currentTimeMillis());
        System.out.println("SQL Date: " + sqlDate); // Output: SQL Date: 2024-07-08
    }
}   

Output:

 
SQL Date: 2024-07-16

File Name: SqlTimeExample.java

import java.sql.Time;
public class SqlTimeExample {
    public static void main(String[] args) {
        Time sqlTime = new Time(System.currentTimeMillis());
        System.out.println("SQL Time: " + sqlTime); // Output: SQL Time: 15:23:01
    }
}   

Output:

 
SQL Time: 16:35:32

3. SqlTimestampExample.java

import java.sql.Timestamp;
public class SqlTimestampExample {
    public static void main(String[] args) {
        Timestamp sqlTimestamp = new Timestamp(System.currentTimeMillis());
        System.out.println("SQL Timestamp: " + sqlTimestamp); // Output: SQL Timestamp: 2024-07-08 15:23:01.123456789
    }
}   

Output:

 
SQL Timestamp: 2024-07-16 16:36:51.847

Usage in JDBC

When interacting with databases in Java, the classes java.sql.Date, java.sql.Time, and java.sql.Timestamp are used to retrieve and set date and time values efficiently. For retrieving values, a ResultSet object is typically used to fetch data from the database.

The methods getDate(), getTime(), and getTimestamp() from the ResultSet class are employed to extract date, time, and timestamp values respectively from the result set. These methods return objects of java.sql.Date, java.sql.Time, and java.sql.Timestamp that can then be used within the application for further processing or display.

Setting values involves preparing an SQL statement, often using a PreparedStatement object, and specifying the values for date, time, and timestamp parameters using the setDate(), setTime(), and setTimestamp() methods. These methods take parameters of the corresponding java.sql classes, ensuring the data is correctly formatted and stored in the database. Proper use of these methods ensures that the date and time data is handled accurately, maintaining the integrity and consistency of the database records. This approach allows for seamless integration between Java applications and SQL databases, facilitating effective data manipulation and retrieval operations.

Conclusion

java.sql.Date, java.sql.Time, and java.sql.Timestamp are designed to handle specific types of date and time information in Java applications interacting with databases. java.sql.Date is for date-only values, java.sql.Time is for time-only values, and java.sql.Timestamp includes both date and time with high precision. Understanding their differences helps in choosing the right type for your application's requirements.

Next TopicFloatbuffer-mark-methods-in-java-with-examples

← prev next →