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
The CAST expression can be used to convert between data types:
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
To get today's date without a time fraction, you can write:
SELECT CAST(SYSDATE AS DATE)