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.
|
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.
|