The driver supports the following data types and time, date, and interval functions.
timestamp_exp – The timestamp expression can be a column name, the result of another scalar function, or an ODBC time/date/timestamp escape with data types SQL_CHAR, SQL_VARCHAR, SQL_TYPE_TIME, SQL_TYPE_DATE, or SQL_TYPE_TIMESTAMP.date_exp – The date expression can be a column name, the result of another scalar function, or an ODBC date/timestamp escape with the following data types: SQL_CHAR, SQL_VARCHAR, SQL_TYPE_DATE, or SQL_TYPE_TIMESTAMP.time_exp – The time expression can be a column name, the result of another scalar function, or an ODBC time/timestamp escape with the following data types: SQL_CHAR, SQL_VARCHAR, SQL_TYPE_TIME, or SQL_TYPE_TIMESTAMP.| Function | ODBC version | Technical description |
|---|---|---|
CURRENT_DATE() |
3.0 | Returns the current date. |
CURRENT_TIME[( time-precision )] |
3.0 | Returns the current local time with optional precision for seconds. |
CURRENT_TIMESTAMP[( timestamp-precision )] |
3.0 | Returns the current local date and time as a timestamp with optional precision for seconds. |
CURDATE() |
3.0 | Returns the current date. |
CURTIME() |
3.0 | Returns the current local time. |
DAYOFMONTH( date_exp ) |
1.0 | Returns the day of the month (1-31) based on the given date. |
DAYOFWEEK( date_exp ) |
1.0 | Returns the day of the week (1-7, where 1 represents Sunday). |
DAYOFYEAR( date_exp ) |
1.0 | Returns the day of the year (1-366) based on the given date. |
EXTRACT( extract-field FROM extract-source ) |
3.0 | Returns a specific component (extract-field) from a datetime or interval expression (extract-source). The extract-field argument can be one of the following: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. |
HOUR( time_exp ) |
1.0 | Returns the hour (0-23) based on the given time value. |
MINUTE( time_exp ) |
1.0 | Returns the minute component of time_exp as an integer in the range of 0 to 59. |
MONTH( date_exp ) |
1.0 | Returns the month as an integer value in the range of 1 to 12 based on the month field in the provided date_exp. |
NOW() |
1.0 | Returns the current date and time as a timestamp. |
QUARTER( date_exp ) |
1.0 | Returns the calendar quarter for a given date as an integer (1-4). |
SECOND( time_exp ) |
1.0 | Returns the second component of time_exp as an integer in the range of 0 to 59. |
TIMESTAMPADD( interval, integer_exp, timestamp_exp ) |
2.0 | Adds integer_exp intervals of type interval to timestamp_exp and returns a new timestamp. Supported intervals include SQL_TSI_SECOND, SQL_TSI_MINUTE, SQL_TSI_HOUR, SQL_TSI_DAY, SQL_TSI_WEEK, SQL_TSI_MONTH, SQL_TSI_QUARTER, and SQL_TSI_YEAR. Behavior depends on the data type of timestamp_exp. |
WEEK( date_exp ) |
1.0 | Returns the week number (1-53) from the week field in date_exp. |
YEAR( date_exp ) |
1.0 | Returns the year from the year field in date_exp. |