Try OpenEdge Now
skip to main content
SQL Reference
ODBC Reference : ODBC Scalar Functions : Scalar functions : Date and time functions
 
Date and time functions
The table in this section lists the date and time functions that ODBC supports.
The date and time functions listed can take 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 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 68. Date and time functions supported by ODBC
Function
Returns
CURRENT DATE()
(ODBC 3.6)
Current date.
CURRENT_TIME
[(time-precision)](ODBC 3.6)
Current local time. The time-precisionargument determines the seconds precision of the returned value.
CURRENT_TIMESTAMP
[(timestamp-precision)](ODBC 3.6)
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 date 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).
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-366).
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:
*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.