4. Elements of QUEL Statements : Functions : Scalar : Numeric
 
Share this page                  
Numeric
The numeric functions are listed in the following table:
Name
Operand Type
Result Type
Description
abs(n)
all numeric types and money
same as n
Absolute value of n
atan(n)
all numeric types and money
float
Arctangent of n; returns a value from
(-pi/2) to pi/2
cos(n)
all numeric types and money
float
Cosine of n; returns a value from -1 to 1
exp(n)
all numeric types and money
float
Exponential of n
log(n)
all numeric types and money
float
Natural logarithm of n
mod(n,b)
i4,
i2,
i1
same as b
n modulo b. The result is the same data type as b
sin(n)
all numeric types and money
float
Sine of n; returns a value from -1 to 1
sqrt(n)
all numeric types and money
float
Square root of n
For trigonometric functions (atan(), cos(), and sin()), you must specify arguments in radians. To convert degrees to radians, use the following formula:
radians = degrees/360 * 2 * pi
To obtain a tangent, you must divide sin() by cos().