Get Date From MySql : Date Time Timestamp « Database SQL JDBC « Java

Get Date From MySql

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GetDateFromMySql {
  public static Connection getMySQLConnection() throws Exception {
    String driver = "";
    String url = "jdbc:mysql://localhost/databaseName";
    String username = "root";
    String password = "root";
    return DriverManager.getConnection(url, username, password);

  public static void main(String args[]) {
    ResultSet rs = null;
    Connection conn = null;
    Statement stmt = null;
    try {
      conn = getMySQLConnection();
      stmt = conn.createStatement();
      rs = stmt.executeQuery("select timeCol, dateCol, dateTimeCol from dateTimeTable");
      while ( {
        java.sql.Time dbSqlTime = rs.getTime(1);
        java.sql.Date dbSqlDate = rs.getDate(2);
        java.sql.Timestamp dbSqlTimestamp = rs.getTimestamp(3);
        System.out.println("dbSqlTime=" + dbSqlTime);
        System.out.println("dbSqlDate=" + dbSqlDate);
        System.out.println("dbSqlTimestamp=" + dbSqlTimestamp);

        java.util.Date dbSqlTimeConverted = new java.util.Date(dbSqlTime.getTime());
        java.util.Date dbSqlDateConverted = new java.util.Date(dbSqlDate.getTime());
        System.out.println("in standard date");
    } catch (Exception e) {
    } finally {
      try {
      } catch (SQLException e) {

Related examples in the same category

1.Convert java.sql.Timestamp to long for easy compare
2.Get java.sql.Timestamp fro current time
3.Get date from Oracle
4.Insert Date, time and date time data to Oracle
5.Construct java.sql.Timestamp from string
6.Demo PreparedStatement Set Time
7.Demo PreparedStatement Set Timestamp
8.Demo PreparedStatement Set Date
9.Compare two times
10.Convert an Object to a DateTime, without an Exception
11.Convert an Object to a Timestamp, without an Exception
12.Convert an Object to a java.sql.Time
13.Timestamp parse
14.Parse date and time
15.convert Strings to Dates and Timestamps and vice versa.
16.Convert into java.sql.Time (or into java.util.Calendar)
17.A method to get the current date and time to use in a timestamp
18.A method to get the current date to use in a timestamp
19.Get today's Timestamp
20.Convert String To Timestamp
21.Format Timestamp
22.Convert a timestamp (= millisecs) to a concise string
23.Get Date stamp