ODBC and SOLID-Only SQL Functions

Previous Next

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

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 )