Hi Friend,

We are providing you a code that will retrieve the date from the MySql database. For this we have create a table date(id,myDate).

import java.sql.*;

public class GetDateFromDatabase {
public static void main(String args[]) {

String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";;

String GET_RECORD = "select * from date";
ResultSet rs = null;
Connection conn = null;
Statement stmt = null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url, "root", "root");

stmt = conn.createStatement();
rs = stmt.executeQuery(GET_RECORD);
while (rs.next()) {
java.sql.Date dbSqlDate = rs.getDate(2);
System.out.println("date is=" + dbSqlDate);
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}

Hope that this will help you.

Thanks