e288. listing the time and date functions supported by a database.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 21 行

This example gets a list of time and date functions that a database supports. 
    try {
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Get the list of time and date functions
        String timedateFunctions[] = dbmd.getTimeDateFunctions().split(",\\s*");
    } catch (SQLException e) {
    }

Examples in an Oracle database include: 
    ADD_MONTHS, LAST_DAY, MONTHS_BETWEEN, NEW_TIME, NEXT_DAY, ROUND,
    SYSDATE, TRUNC

Examples in a MySQL database include: 
    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