• 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 SQL_CHAR, SQL_VARCHAR, SQL_DATE, or SQL_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 SQL_CHAR, SQL_VARCHAR, SQL_TIME, or SQL_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 SQL_CHAR, SQL_VARCHAR, SQL_TIME, SQL_DATE, or SQL_TIMESTAMP.
Table 8. Scalar Time and Date Functions 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. DAYNAME(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) 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). Timestamp calculated by adding integer_exp intervals of type interval to time_exp. interval can be one of the following values: 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.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |