NeuronEX

English

简体中文

English

简体中文

Appearance

Contact Us

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.