Math Functions

ACOS() 

acos(a) - Returns inverse cosinus of a.

Example:
acos(0) -> 1.5707963

ASIN()
asin(a) - Returns inverse sinus of a.

Example:
asin(1) -> 1.5707963

ATAN()
atan(a) - Returns inverse tangent of a.

Example: 
atan(tan(1)) -> 1

ATAN2()
atan2(a,b) - Returns inverse tangent of a/b.

Example:
atan2(4,-3) -> -0.9272952

CEIL()
ceil(n) - Returns the smallest BIGINT that is greater than or equal to n.

Example:
ceil(1.7) -> 2

COS()
cos(r) - Returns cosinus of radians r.

Example:
cos(pi()/2) -> 0

DEGREES()
degrees(r) - Returns degrees of radians r (convert radians to degrees).

Example:
degrees(pi()/2) -> 90

EXP()
exp(a) - Returns exponential of argument a.

Example:
exp(1) -> 2.7182818

FLOOR()
floor(n) - Returns the largest BIGINT that is less than or equal to n.

Example:
floor(1.7) -> 1

LN()
ln(a) - Returns the natural logarithm of number a. Natural logarithms are based on the constant e.

Example:
ln(95) -> 4.5538769

LOG()
log(a) - Returns the natural logarithm of number a. Natural logarithms are based on the constant e.

Example:
log(95) -> 4.5538769

LOG10()
Log10(a) - Returns the natural logarithm of number a based on the constant 10.

Example:
log10(100) -> 2

RADIANS()
radians(d) - Returns radians of degrees d (convert degrees to radians).

Example:
radians(90) -> 1.5705963

ROUND()
round(n,d) - Rounds decimal number n to the number of decimals d specified. If d is omitted, the function will round the number to 0 decimal places.

Examples:
round(125.315) -> 125 
round(125.315, 2) -> 125.32
round(125.315, -2) -> 100

PI()
pi() - Returns value of PI.

Example:
pi() -> 3.1415927

POW()
pow(a,b) - Returns a raised to the power of b (a^b).

Example:
pow(2,3) -> 8

SIGN()
sign(a) - Returns the sign of number a. The possible return value is -1 if the number is negative, 0 if the number is zero, or 1 if the number is positive.

Example:
sign(-2) -> -1

SIN()
sin(r) - Returns sinus of radians r.

Example:
sin(pi()/2) -> 1

SQRT()
sqrt(a) - Returns square root of a.

Example:
sqrt(4) -> 2

TAN()
tan(r) - Returns tangent of radians r.

Example:
tan(pi()/4) -> 1