|
<< Click to Display Table of Contents >> Mathematical Functions |
  
|
|
<< Click to Display Table of Contents >> Mathematical Functions |
|
Absolute Database supports the following mathematical functions:
Function |
Description |
ABS |
Returns the absolute value of a number |
ACOS |
Returns the inverse cosine of a given number |
ASIN |
Returns the inverse sine of a given number |
ATAN |
Returns the arctangent of a number |
CEIL |
Rounds variables up toward positive infinity |
COS |
Returns the cosine of an angle |
EXP |
Returns the exponential of a number |
FLOOR |
Rounds variables toward negative infinity |
LOG |
Returns the natural log of a real expression |
POWER |
Raises Base to any power |
RAND |
Generates random numbers within a specified range |
ROUND |
Returns the value of a number rounded to the specified length or precision. |
SIGN |
Indicates whether a numeric value is positive, negative, or zero |
SIN |
Returns the sine of the angle in radians |
SQR |
Returns the square of a number |
SQRT |
Returns the square root of a number |
Returns the absolute value of a number.
Example:
ABS(-2.9) returns 2.9
Returns the inverse cosine of a given number.
Example:
ACOS(1) returns 0
Returns the inverse sine of a given number.
Example:
ASIN(0) returns 0
Returns the arctangent of a number.
Example:
ATAN(0) returns 0
The ceil function returns the smallest integer value that is greater than or equal to a number.
Example:
CEIL(11.22) returns 12
The cos function returns the cosine of a number.
Example:
COS(-3.15) returns -0.999964658471342
The exp function returns e raised to the nth power, where e = 2.71828183.
Example:
EXP(3) returns 20.0855369231877
The floor function returns the largest integer value that is equal to or less than a number.
Example:
FLOOR(3.67) returns 3
The log function returns the natural logarithm of a number.
Example:
LOG(20) returns 2.99573227355399
The power function returns base raised to the exponent power.
Example:
POWER(3,2) returns 9
Returns a string equal to that in numeric_exp with all uppercase characters converted to lowercase.
Example:
RAND(10) may return 0..9
The round function returns a number rounded to the specified length or precision.
The decimals parameter is the precision to which numeric_exp is to be rounded
The rounding_mode possible values are:
•HalfEven - Round to nearest or to even whole number. ("Banker's Rounding")
•HalfPos - Round to nearest or toward positive.
•HalfNeg - Round to nearest or toward negative.
•HalfDown - Round to nearest or toward zero.
•HalfUp - Round to nearest or away from zero.
•RndNeg - Round toward negative. (i.e. Floor)
•RndPos - Round toward positive. (i.e. Ceil)
•RndDown - Round toward zero. (i.e. Trunc)
•RndUp - Round away from zero.
Example:
ROUND(4.6) returns 5
ROUND(4.56, 1) returns 4.6
ROUND(1.235, 2) returns 1.24
ROUND(1.245, 2) returns 1.24
ROUND(1.245, 2, HalfPos) returns 1.25
The sign function returns a value indicating the sign of a number.
Example:
SIGN(10) returns 1
The sin function returns the sine of a number.
Example:
SIN(3) returns 0.141120008059867
Returns the square of a number.
Example:
SQR(3) returns 9
The sqrt function returns the square root of a number.
Example:
SQRT(9) returns 3
__________________________