Tutorialspoint

1 Answer
Vikyath Ram

This method retrieves the list of time and date functions supported by the current database. The names returned by this method are the Open CLI time and date function names.

This method returns a String value holding the list of functions separated by commas (",").

To get the list of the time and date functions supported by the underlying database −

  • Make sure your database is up and running.
  • Register the driver using the registerDriver() method of the DriverManager class. Pass an object of the driver class corresponding to the underlying database.
  • Get the connection object using the getConnection() method of the DriverManager class. Pass the URL the database and, user name, password of a user in the database, as String variables.
  • Get the DatabaseMetaData object with respect to the current connection using the getMetaData() method of the Connection interface.

Finally, get the list of time and date functions supported by the underlying database, by invoking the getTimeDateFunctions() method of the DatabaseMetaData class.

Following JDBC program establishes connection with MySQL database and, retrieves the list of time and date functions supported by the underlying database.

Example

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.StringTokenizer;
public class DatabaseMetadata_getTimeDateFunctions {
   public static void main(String args[]) throws SQLException {
      //Registering the Driver
      DriverManager.registerDriver(new com.mysql.jdbc.Driver());
      //Getting the connection
      String url = "jdbc:mysql://localhost/mydatabase";
      Connection con = DriverManager.getConnection(url, "root", "password");
      System.out.println("Connection established......");
      //Retrieving the meta data object
      DatabaseMetaData metaData = con.getMetaData();
      //Retrieving the list of time and date functions
      String numeric_functions = metaData.getTimeDateFunctions();
      StringTokenizer tokenizer = new StringTokenizer(numeric_functions, ",");
      while(tokenizer.hasMoreElements()) {
         System.out.println(tokenizer.nextToken());
      }
      System.out.println(" ");
   }
}

Output

Connection established......
DAYOFWEEK
WEEKDAY
DAYOFMONTH
DAYOFYEAR
MONTH
DAYNAME
MONTHNAME
QUARTER
WEEK
YEAR
HOUR
MINUTE
SECOND
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
FROM_DAYS
DATE_FORMAT
TIME_FORMAT
CURDATE
CURRENT_DATE
CURTIME
CURRENT_TIME
NOW
SYSDATE
CURRENT_TIMESTAMP
UNIX_TIMESTAMP
FROM_UNIXTIME
SEC_TO_TIME
TIME_TO_SEC

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.