Listing the Time and Date Functions Supported by a Database
This example gets a list of time and date functions that a database supports.
Examples in an Oracle database include:
Examples in a MySQL database include:
try {
DatabaseMetaData dbmd = connection.getMetaData();
// Get the list of time and date functions
String timedateFunctions[] = dbmd.getTimeDateFunctions().split(",\\s*");
} catch (SQLException e) {
}
ADD_MONTHS, LAST_DAY, MONTHS_BETWEEN, NEW_TIME, NEXT_DAY, ROUND,
SYSDATE, TRUNC
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
Post a comment