Skip to content

Mathematical Functions

Mathematical functions perform many of the common mathematical operations. They take numeric input and return numeric output.

ABS

text
abs(col)

The absolute value of a value.

ACOS

text
acos(col)

The inverse cosine of a number of radians.

ASIN

text
asin(col)

The inverse sine of a number of radians.

ATAN

text
atan(col)

The inverse tangent of a number of radians.

ATAN2

text
atan2(col1, col2)

The angle, in radians, between the positive x-axis and the (x, y) point defined in the two arguments.

BITAND

text
bitand(col1, col2)

Performs a bitwise AND on the bit representations of the two Int(-converted) arguments.

BITOR

text
bitor(col1, col2)

Performs a bitwise OR of the bit representations of the two arguments.

BITXOR

text
bitxor(col1, col2)

Performs a bitwise XOR on the bit representations of the two Int(-converted) arguments.

BITNOT

text
bitnot(col1)

Performs a bitwise NOT on the bit representations of the Int(-converted) argument.

CEIL

CEIL() is a synonym for CEILING().

CEILING

text
ceiling(col)

The smallest integer value that is greater than or equal to the argument.

COS

text
cos(col)

The cosine of a number of radians.

COSH

text
cosh(col)

The hyperbolic cosine of a number.

EXP

text
exp(col)

Returns Euler's number e raised to the power of a double value.

FLOOR

text
floor(col)

Returns the largest integer value not greater than X.

LN

text
ln(col)

Returns the natural logarithm of a double value.

LOG

text
log(col)

or

log(b, col)

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

text
mod(col1, col2)

Returns the remainder of the division of the first argument by the second argument.

PI

text
pi()

Returns the value of π (pi).

POW

POW() is a synonym for POWER().

POWER

text
power(col1, col2)

Returns the value of the first argument raised to the power of the second argument.

RAND

text
rand()

Returns a random number between 0.0 (inclusive) and 1.0 (exclusive).

ROUND

text
round(col)

Returns the closest BIGINT value to the argument.

SIGN

text
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

text
sin(col)

The sine of a numbmulti_column_functions.mder in radians.

SINH

text
sinh(col)

The hyperbolic sine of a number.

SQRT

text
sqrt(col)

Returns the positive square root of a double value.

TAN

text
tan(col)

The tangent of a number of radians.

TANH

text
tanh(col)

The hyperbolic tangent of a number.