Skip to content
XTDB

Numeric functions

Notes:

  • If any input expression is null, the result will also be null.

  • If all arguments are integers, the result will also be an integer; otherwise, all arguments will be cast to floating-point values before applying the function. Particularly, the division function performs integer division if it’s only given integer values.

  • If the result would under-/overflow the widest type of the input arguments, a runtime exception will be thrown.

  • Trying to divide by zero will result in a runtime exception.

Basic arithmetic functions

The standard arithmetic functions are available:

  • expr1 + expr2 (addition)

  • expr1 - expr2 (subtraction)

  • expr1 * expr2 (multiplication)

  • expr1 / expr2 (division)

Other numeric functions

ABS(x)

absolute value of x

CEIL(x) | CEILING(x)

nearest integer greater than or equal to x

EXP(x)

ℯ (base of natural logarithms) raised to the power of x

FLOOR(x)

nearest integer less than or equal to x

LN(x)

natural logarithm

LOG(x, y)

logarithm of x, base y

LOG10(x)

logarithm of x, base 10

MOD(x, y)

modulus of x, base y

POWER(x, y)

x raised to the `y`th power

SQRT(x)

square root

Trigonometric functions

  • ACOS(x) (inverse cosine)

  • ASIN(x) (inverse sine)

  • ATAN(x) (inverse tangent)

  • COS(x) (cosine)

  • COSH(x) (hyperbolic cosine)

  • SIN(x) (sine)

  • SINH(x) (hyperbolic sine)

  • TAN(x) (tangent)

  • TANH(x) (hyperbolic tangent)

Notes:

  • Arguments and results in radians