Arithmetic Functions

<< Click to Display Table of Contents >>

Navigation:  Apollo SQL > Arithmetic Functions >

Arithmetic Functions

Apollo SQL currently supports the following arithmetic functions:

 

Abs

Returns the absolute value of the argument.

ArcTan

Calculates the arctangent of the given number.

Cos

Returns the cosine of the angle X, in radians.

Exp

Returns the value of e raised to the power of X, where e is the base of the natural logarithms.

Frac

Returns the fractional part of the argument X.

Int

Returns the Integer position of a Float value.

Ln

Returns the natural logarithm (Ln(e) = 1) of the float-type expression X.

MINOF

Returns the lowest value of the n figures.

MAXOF

Returns the highest value of the n figures.

Pi

Pi, approximated as 3.1415926535897932385.

Power

Raises Base to any power.

Round

Rounds a float-type value to an integer-type value.

RoundDec

Rounds a float-type value to a given precision (decimals).

Sin

Returns the sine of the argument.

Sqr

Returns the square of the argument.

Sqrt

Returns the square root of the argument.

Trunc

Truncates a float-type value to an integer-type value.

TruncDec

Truncates a float-type value to a given precision (decimals).

 

See Also

Aggregate Functions, Conditional Functions, String Functions