Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
The following table lists the SQL Scalar functions supported in AppMaster Builder's Online Express and Customizer rules:
- ABS, ABSVAL
- ACOS
- ASIN
- ATAN
- ATANH
- CEILING, CEIL
- CHAR
- COALESCE (Customizer rules only)
- COS
- COSH
- DATE
- DAY
- DAYOFMONTH
- DAYOFWEEK
- DAYOFWEEK_ISO (Customizer rules only)
- DAYOFYEAR
- DAYS
- DECIMAL
- DEGREES
- DIGITS
- EXP
- FLOAT
- FLOOR
- HEX
- HOUR
- INTEGER
- JULIAN_DAY
- LEFT
- LENGTH
- LOWER, LCASE
- LOG, LN
- LOG10
- LTRIM
|
- MICROSECOND
- MIDNIGHT_SECONDS
- MINUTE
- MOD
- MONTH
- POWER
- QUARTER
- RAND
- RADIANS
- REAL
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SIN
- SINH
- SMALLINT (Customizer rules only)
- SQRT
- SUBSTR
- SUBSTRING
- TAN
- TANH
- TIME
- TIMESTAMP
- TRUNC
- UPPER, UCASE
- VALUE
- VARGRAPHIC
- WEEK
- WEEK_ISO (Customizer rules only)
- YEAR
|