ODBC and SOLID-Only SQL Functions
Functions that can only be used when running on ODBC or SOLID are listed in the following table.
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 ))
To get today's date without a time fraction, you can write:
SELECT CAST( SYSDATE AS DATE )