Math
Absolute value
Returns the absolute value of a variable –> learn more
ABS(@variable)
Return type
dynamic (input-dependent)
Parameters
Arithmetic
Compute simple arithmetic (+, -, *, /) –> learn more
(@expression @operator @expression_2)
Return type
dynamic (input-dependent)
Parameters
Ceiling
Returns the smallest integral value that is not less than the provided value –> learn more
CEILING(@variable)
Return type
float
Parameters
Integer divide
Divide two integer values, rounding down any remainder –> learn more
DIV(@expression, @expression_2)
Return type
integer
Parameters
e ^ x
Compute the natural exponential of a value –> learn more
EXP(@expression)
Return type
float
Parameters
Floor
Returns the largest integral value that is not greater than the provided value –> learn more
FLOOR(@variable)
Return type
float
Parameters
Greatest
Find the largest of several values –> learn more
GREATEST(@expression)
Return type
dynamic (input-dependent)
Parameters
Is infinity
Return true if the value is positive or negative infinity, false otherwise. Returns NULL for NULL inputs –> learn more
IS_INF(@variable)
Return type
boolean
Parameters
Is NaN
Determines whether input value is not a number (NaN) –> learn more
IS_NAN(@variable)
Return type
boolean
Parameters
Least
Find the smallest of several values –> learn more
LEAST(@expression)
Return type
dynamic (input-dependent)
Parameters
Log
Compute the logarithm of a value to a provided base; generates an error if the variable is <= 0. If no base is provided, defaults to natural log –> learn more
LOG(@expression[, @literal])
Return type
float
Parameters
Mod
Modulo: compute the remainder of the division of two integers –> learn more
MOD(@expression, @expression_2)
Return type
integer
Parameters
Power
Raises a value to a power –> learn more
POW(@expression, @expression_2)
Return type
float
Parameters
Random
Generate a pseudo-random float between [0, 1) –> learn more
RAND()
Return type
float
Parameters
Round
Rounds a value to the nearest integer (or, if specified, to the provided number of decimal places) –> learn more
ROUND(@expression[, @literal])
Return type
float
Parameters
Safe divide
Equivalent to the divisor operator, but returns null if an error occurs, such as a division by zero error –> learn more
SAFE_DIVIDE(@expression, @expression_2)
Return type
float
Parameters
Sign
Returns the sign (-1, 0, +1) of a numeric variable –> learn more
SIGN(@variable)
Return type
integer
Parameters
Sqrt
Compute the square root of a value; generates an error if the variable is less than 0 –> learn more
SQRT(@expression)
Return type
float
Parameters
Truncate
Similar to round, but rounds to the nearest integer whose absolute value is not greater than the absolute value of the provided variable (always rounds towards zero) –> learn more
TRUNC(@expression[, @literal])
Return type
float
Parameters
Last updated
Was this helpful?