# Mathematical Functions
Mathematical functions perform many of the common mathematical operations. They take numeric input and return numeric output.
# ABS
abs(col)
The absolute value of a value.
# ACOS
acos(col)
The inverse cosine of a number of radians.
# ASIN
asin(col)
The inverse sine of a number of radians.
# ATAN
atan(col)
The inverse tangent of a number of radians.
# ATAN2
atan2(col1, col2)
The angle, in radians, between the positive x-axis and the (x, y) point defined in the two arguments.
# BITAND
bitand(col1, col2)
Performs a bitwise AND on the bit representations of the two Int(-converted) arguments.
# BITOR
bitor(col1, col2)
Performs a bitwise OR of the bit representations of the two arguments.
# BITXOR
bitxor(col1, col2)
Performs a bitwise XOR on the bit representations of the two Int(-converted) arguments.
# BITNOT
bitnot(col1)
Performs a bitwise NOT on the bit representations of the Int(-converted) argument.
# CEIL
CEIL() is a synonym for CEILING().
# CEILING
ceiling(col)
The smallest integer value that is greater than or equal to the argument.
# COS
cos(col)
The cosine of a number of radians.
# COSH
cosh(col)
The hyperbolic cosine of a number.
# EXP
exp(col)
Returns Euler's number e raised to the power of a double value.
# FLOOR
floor(col)
Returns the largest integer value not greater than X.
# LN
ln(col)
Returns the natural logarithm of a double value.
# LOG
log(col)
or
log(b, col)
2
3
4
5
If called with one argument, the function returns the decimal logarithm of X. If X is less than or equal to 0, the function returns nil; if called with two arguments, the function returns the base B logarithm of X. Returns nil if X is less than or equal to 0, or if B is less than or equal to 1.
# MOD
mod(col1, col2)
Returns the remainder of the division of the first argument by the second argument.
# PI
pi()
Returns the value of π (pi).
# POW
POW() is a synonym for POWER().
# POWER
power(col1, col2)
Returns the value of the first argument raised to the power of the second argument.
# RAND
rand()
Returns a random number between 0.0 (inclusive) and 1.0 (exclusive).
# ROUND
round(col)
Returns the closest BIGINT value to the argument.
# SIGN
sign(col)
Returns the signum function of the argument. When the sign of the argument is positive, 1 is returned. When the sign of the argument is negative, -1 is returned. If the argument is 0, 0 is returned.
# SIN
sin(col)
The sine of a numbmulti_column_functions.mder in radians.
# SINH
sinh(col)
The hyperbolic sine of a number.
# SQRT
sqrt(col)
Returns the positive square root of a double value.
# TAN
tan(col)
The tangent of a number of radians.
# TANH
tanh(col)
The hyperbolic tangent of a number.