Scalar Functions
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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 OpenAccess SDK Clients when used with the OpenAccess SDK SQL engine, as shown in the following tables.
Example
SELECT {fn UCASE(NAME)} FROM EMP
Note: Refer to the documentation for your third-party SQL engine for its supported scalar functions.
Scalar Functions Supported by the OpenAccess SDK SQL Engine
| String Functions | Numeric Functions | Timedate Functions | System Functions |
| ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE INSERT LCASE LEFT LENGTH LOCATE LOWER LTRIM OCTET_LENGTH POSITION REPEAT REPLACE RIGHT RTRIM SPACE SUBSTR SUBSTRING UCASE UPPER |
ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE |
CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME CURTIMESTAMP DATEADD DATEDIFF DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIMESTAMPADD TIMESTAMPDIFF WEEK YEAR |
DATABASE IFNULL USERNAME |