ODBC and SOLID-Only SQL Functions

Functions that can only be used when running on ODBC or SOLID are listed in the following table.

ODBC and SOLID-only SQL functions

ODBC and SOLID-only SQL functions
CONVERT (see NOTE)	CURDATE	CURTIME
DAYOFYEAR	HOUR	MINUTE
MONTH	MONTHNAME	QUARTER
REPEAT	REPLACE	ROWNUM
SECOND	TIMESTAMPADD	TIMESTAMPDIFF
TRUNCATE	WEEK

The CAST expression can be used to convert between data types:

EXAMPLE 1:

To compute the sum of numbers stored in a column of the data type CHAR, you can write:

SELECT SUM(CAST(EMPNO AS INTEGER))FROM EMPLOYEE

EXAMPLE 2:

To get today's date without a time fraction, you can write:

SELECT CAST(SYSDATE AS DATE)