ArangoDB v2.8 reached End of Life (EOL) and is no longer supported.
This documentation is outdated. Please see the most recent version here: Try latest
Numeric functions
AQL offers some numeric functions for calculations. The following functions are supported:
-
FLOOR(value): Returns the integer closest but not greater to value
-
CEIL(value): Returns the integer closest but not less than value
-
ROUND(value): Returns the integer closest to value
-
ABS(value): Returns the absolute part of value
-
SQRT(value): Returns the square root of value
-
POW(base, exp): Returns the base to the exponent exp
-
RAND(): Returns a pseudo-random number between 0 and 1