skip to main content
SQL Escape Sequences : Scalar Functions
 

Scalar Functions

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.
 
Table 35: 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