Get date from Oracle : Date Time Timestamp « Database SQL JDBC « Java

Get date from Oracle

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

public class GetDateFromOracle {
  public static Connection getConnection() throws Exception {
    String driver = "oracle.jdbc.driver.OracleDriver";
    String url = "jdbc:oracle:thin:@localhost:1521:databaseName";
    return DriverManager.getConnection(url, "name", "password");

  public static void main(String args[]) {
    String GET_RECORD = "select date_column, time_column, "
        + "timestamp_column from TestDates where id = ?";
    ResultSet rs = null;
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection();
      pstmt = conn.prepareStatement(GET_RECORD);
      pstmt.setString(1, "0001");
      rs = pstmt.executeQuery();
      while ( {
        java.sql.Date dbSqlDate = rs.getDate(1);
        java.sql.Time dbSqlTime = rs.getTime(2);
        java.sql.Timestamp dbSqlTimestamp = rs.getTimestamp(3);
        System.out.println("dbSqlDate=" + dbSqlDate);
        System.out.println("dbSqlTime=" + dbSqlTime);
        System.out.println("dbSqlTimestamp=" + dbSqlTimestamp);
    } 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 Date From MySql
3.Get java.sql.Timestamp fro current time
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