The driver supports the scalar functions in the following table. Note that your database system may not support all these functions. Refer to the documentation for your database system to find out which functions are supported by your database.

In addition, you can also determine the supported scalar functions by using DatabaseMetaData methods.

You can use scalar functions in SQL statements with the following syntax:

{fn scalar-function}

where:

scalar-function
is a scalar function supported by the drivers, as listed in the following table.

Example:

SELECT id, name FROM emp WHERE name LIKE {fn UCASE('Smith')}

Refer to Scalar functions in the Progress DataDirect for JDBC Drivers Reference for more information.

Table 1. Supported Scalar Functions
String Functions Numeric Functions Timedate Functions System Functions
ASCII ABS CURDATE CURSESSIONID
BIT_LENGTH ACOS CURRENT_DATE DATABASE
CHAR ASIN CURRENT_TIME IDENTITY
CHAR_LENGTH ATAN CURRENT_TIMESTAMP USER
CHARACTER_LENGTH ATAN2 CURTIME
CONCAT BITAND DATEDIFF
DIFFERENCE BITOR DATE_ADD
HEXTORAW BITXOR DATE_SUB
INSERT CEILING DAY
LCASE COS DAYNAME
LEFT COT DAYOFMONTH
LENGTH DEGREES DAYOFWEEK
LOCATE EXP DAYOFYEAR
LOCATE_2 FLOOR EXTRACT
LOWER LOG HOUR
LTRIM LOG10 MINUTE
OCTET_LENGTH MOD MONTH
RAWTOHEX PI MONTHNAME
REPEAT POWER NOW
REPLACE RADIANS QUARTER
RIGHT RAND SECOND
RTRIM ROUND SECONDS_SINCE_MIDNIGHT
SOUNDEX ROUNDMAGIC TIMESTAMPADD
SPACE SIGN TIMESTAMPDIFF
SUBSTR SIN TO_CHAR
SUBSTRING SQRT WEEK
UCASE TAN YEAR
UPPER TRUNCATE