Previous Topic Next topic Print topic


SQL Scalar Functions

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
Previous Topic Next topic Print topic