JDBC: Get current Date and Time Example

In this section, you will learn how to get current Date and current time using JDBC API.

Get current Date and Time :

CURDATE() : For current date you can use CURDATE(). It returns current date in the format 'YYYY-MM-DD'
You can get current date by writing  - SELECT CURDATE()
You will get output - 2012-09-28

CURTIME() : For current time you can call CURTIME(). It returns current time in the format of 'HH:MM:SS'.
You can get current date by writing  - SELECT CURTIME();
You will get output - 17:04:30

Example :  In this example we are selecting current date and current time by using MySql methods CURDATE() and CURTIME().

package jdbc;

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

class CurrentDateTime{
	public static void main(String[] args) {
		System.out.println("Get Current Date and Time Example...");
		Connection con = null;
		Statement statement = null;
		ResultSet rs = null;
		String url = "jdbc:mysql://localhost:3306/";
		String dbName = "students";
		String driverName = "com.mysql.jdbc.Driver";
		String userName = "root";
		String password = "root";
		try {
			// Connecting to the database
			Class.forName(driverName);
			con = DriverManager.getConnection(url + dbName, userName, password);
			try {
				// Creating object of Statement
				statement = con.createStatement();

				// Get current date and current time
				String sql = "SELECT CURDATE(),CURTIME()";
				rs = statement.executeQuery(sql);
				while (rs.next()) {
					System.out.println("Current Date : "+ rs.getDate(1));
					System.out.println("Current Time : "+ rs.getTime(2));
				}
			} catch (SQLException e) {
				System.out.println(e);
			}
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Output :

Get Current Date and Time Example...
Current Date : 2012-09-28
Current Time : 17:04:30

Related Tags for JDBC: Get current Date and Time Example: