The following table lists the date and time functions that JDBC supports.

The date and time functions listed accept the following arguments:

  • date_exp can be a column name, a date or timestamp literal, or the result of another scalar function, where the underlying data type can be represented as CHAR, VARCHAR, DATE, or TIMESTAMP.
  • time_exp can be a column name, a timestamp or timestamp literal, or the result of another scalar function, where the underlying data type can be represented as CHAR, VARCHAR, TIME, or TIMESTAMP.
  • timestamp_exp can be a column name; a time, date, or timestamp literal; or the result of another scalar function, where the underlying data type can be represented as CHAR, VARCHAR, TIME, DATE, or TIMESTAMP.
Table 1. Scalar Time and Date Functions
Function Returns
CURRENT_DATE() Current date.
CURRENT_TIME[(time-precision)] Current local time. The time-precision argument determines the seconds precision of the returned value.
CURRENT_TIMESTAMP([timestamp-precision]) Current local date and local time as a timestamp value. The timestamp-precision argument determines the seconds precision of the returned timestamp.
CURDATE() Current date as a date value.
CURTIME() Current local time as a time value.
DAYNAME(date_exp) Character string containing a data-source-specific name of the day for the day portion of date_exp.
DAYOFMONTH(date_exp) Day of the month in date_exp as an integer value (1–31).
DAYOFWEEK(date_exp) Day of the week in date_exp as an integer value (1–7).
DAYOFYEAR(date_exp) Day of the year in date_exp as an integer value (1–366).
EXTRACT({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND} FROM datetime_value) Any of the date and time terms can be extracted from datetime_value.
HOUR(time_exp) Hour in time_exp as an integer value (0–23).
MINUTE(time_exp) Minute in time_exp as an integer value (0–59).
MONTH(date_exp) Month in date_exp as an integer value (1–12).
MONTHNAME(date_exp) Character string containing the data source-specific name of the month.
NOW() Current date and time as a timestamp value.
QUARTER(date_exp) Quarter in date_exp as an integer value (1–4).
SECOND(time_exp) Second in date_exp as an integer value (0–59).
TIMESTAMPADD(interval, integer_exp, time_exp) Timestamp calculated by adding integer_exp intervals of type interval to time_exp. interval can be one of the following values:
  • SQL_TSI_FRAC_SECOND
  • SQL_TSI_SECOND
  • SQL_TSI_MINUTE
  • SQL_TSI_HOUR
  • SQL_TSI_DAY
  • SQL_TSI_WEEK
  • SQL_TSI_MONTH
  • SQL_TSI_QUARTER
  • SQL_TSI_YEAR

Fractional seconds are expressed in billionths of a second.
TIMESTAMPDIFF(interval, time_exp1, time_exp2) Integer number of intervals of type interval by which time_exp2 is greater than time_exp1. interval has the same values as TIMESTAMPADD. Fractional seconds are expressed in billionths of a second.
WEEK(date_exp) Week of the year in date_exp as an integer value (1–53).
YEAR(date_exp) Year in date_exp. The range is data-source dependent.