JDBC : Get year from Date

In this section, you will learn how to get year from date.

 
 

Share on Google+Share on Google+

JDBC : Get year from Date

Ads

In this section, you will learn how to get year from date.

JDBC : Get year from Date

In this section, you will learn how to get year from date.

Get year from Date :

In MySql you can get year from the given Date by using year() function.

 YEAR(date) : This method returns the year of the specified date. It ranges from 1000 to 9999 or returns 0 for no date.

You can write sql query as -  sql = "SELECT YEAR('2000-12-31')"

Example :

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

public class JDBCCurrentDate {
	public static void main(String[] args) {
		System.out.println("Get year from date Example...");
		Connection conn = null;
		String url = "jdbc:mysql://localhost:3306/";
		String dbName = "employees";
		String driverName = "com.mysql.jdbc.Driver";
		String userName = "root";
		String password = "root";
		Statement statement = null;
		ResultSet rs;
		try {
			Class.forName(driverName);
			conn = DriverManager
					.getConnection(url + dbName, userName, password);
			statement = conn.createStatement();
			String sql = "SELECT YEAR('2000-12-31')";
			rs = statement.executeQuery(sql);
			System.out.print("Year of given date : - ");
			while (rs.next()) {

				System.out.println(rs.getInt(1));
			}
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Output :

Get year from date Example...
Year of given date : - 2000

Advertisements

Ads

Posted on: October 12, 2012 If you enjoyed this post then why not add us on Google+? Add us to your Circles