Java sql.Date toString() method with example?

JDBCJava 8Object Oriented ProgrammingProgramming

The toString() method of the java.sql.Date class returns the JDBC escape format of the time of the current Date object as String variable.

i.e. using this method, you can convert a Date object to a String.

//Retrieving the Date object
Date dateObj = rs.getDate("DispatchDate");
//Converting the Date object to String format
String date = dateObj.toString();

Example

Let us create a table with name dispatches in MySQL database using CREATE statement as follows −

CREATE TABLE dispatches(
   ProductName VARCHAR(255),
   CustomerName VARCHAR(255),
   DispatchDate date,
   DeliveryTime time,
   Price INT,
   Location VARCHAR(255));

Now, we will insert 5 records in dispatches table using INSERT statements −

insert into dispatches values('Key-Board', 'Raja', DATE('2019-09-01'), TIME('11:00:00'), 7000, 'Hyderabad');
insert into dispatches values('Earphones', 'Roja', DATE('2019-05-01'), TIME('11:00:00'), 2000, 'Vishakhapatnam');
insert into dispatches values('Mouse', 'Puja', DATE('2019-03-01'), TIME('10:59:59'), 3000, 'Vijayawada');
insert into dispatches values('Mobile', 'Vanaja', DATE('2019-03-01'), TIME('10:10:52'), 9000, 'Chennai');
insert into dispatches values('Headset', 'Jalaja', DATE('2019-04-06'), TIME('11:08:59'), 6000, 'Goa');

Following JDBC program establishes connection with the database and retrieves the contents of the dispatches table.

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Date_toString {
   public static void main(String args[]) throws SQLException {
      //Registering the Driver
      DriverManager.registerDriver(new com.mysql.jdbc.Driver());
      //Getting the connection
      String mysqlUrl = "jdbc:mysql://localhost/mydatabase";
      Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");
      System.out.println("Connection established......");
      //Creating a Statement object
      Statement stmt = con.createStatement();
      //Query to retrieve the contents of the dispatches table
      String query = "select * from dispatches";
      //Executing the query
      ResultSet rs = stmt.executeQuery(query);
      while(rs.next()) {
         System.out.println("Product Name: "+rs.getString("ProductName"));
         System.out.println("Customer Name: "+rs.getString("CustomerName"));
         Date dateObj = rs.getDate("DispatchDate");
         //Converting the Date object to String format
         String date = dateObj.toString();
         System.out.println("Date Of Dispatch in String format: "+date);
         System.out.println("Delivery time: "+rs.getTime("DeliveryTime"));
         System.out.println("Location: "+rs.getString("Location"));
         System.out.println();
      }
   }
}

Here, in this program while retrieving the column values we have converted the DispatchDate value from Date object to string format using the toString() method of the Date class and displayed it.

Output

Connection established......
Product Name: Key-Board
Customer Name: Raja
Dispatch Date: 2019-09-01
Delivery time in String format: 11:00:00
Location: Hyderabad
Product Name: Earphones
Customer Name: Roja
Dispatch Date: 2019-05-01
Delivery time in String format: 11:00:00
Location: Vishakhapatnam
Product Name: Mouse
Customer Name: Puja
Dispatch Date: 2019-03-01
Delivery time in String format: 10:59:59
Location: Vijayawada
Product Name: Mobile
Customer Name: Vanaja
Dispatch Date: 2019-03-01
Delivery time in String format: 10:10:52
Location: Chennai
Product Name: Headset
Customer Name: Jalaja
Dispatch Date: 2019-04-06
Delivery time in String format: 11:08:59
Location: Goa
raja
Updated on 30-Jul-2019 22:30:26

Advertisements