Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Mathematical Functions
Previous  Top  Next



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



ABS (numeric_exp)

Returns the absolute value of a number.

Example:
ABS(-2.9) returns 2.9  
 
 
ACOS (numeric_exp)

Returns the inverse cosine of a given number.

Example:
ACOS(1) returns 0  
 
 
ASIN (numeric_exp)

Returns the inverse sine of a given number.

Example:
ASIN(0) returns 0  
 
 
ATAN (numeric_exp)

Returns the arctangent of a number.

Example:
ATAN(0) returns 0  
 
 
CEIL (numeric_exp)

The ceil function returns the smallest integer value that is greater than or equal to a number.

Example:
CEIL(11.22) returns 12  
 
 
COS (numeric_exp)

The cos function returns the cosine of a number.

Example:
COS(-3.15) returns -0.999964658471342  
 
 
EXP (numeric_exp)

The exp function returns e raised to the nth power, where e = 2.71828183.

Example:
EXP(3) returns 20.0855369231877  
 
 
FLOOR (numeric_exp)

The floor function returns the largest integer value that is equal to or less than a number.

Example:
FLOOR(3.67) returns 3  
 
 
LOG (numeric_exp)

The log function returns the natural logarithm of a number.

Example:
LOG(20) returns 2.99573227355399  
 
 
POWER (base, exponent)

The power function returns base raised to the exponent power.

Example:
POWER(3,2) returns 9  
 
 
RAND (numeric_exp)

Returns a string equal to that in numeric_exp with all uppercase characters converted to lowercase.

Example:
RAND(10) may return 0..9  
 
 
ROUND (numeric_exp, [ decimals = 0 [, rounding_mode = HalfEven ] ])

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  
 
 
SIGN (numeric_exp)

The sign function returns a value indicating the sign of a number.

Example:
SIGN(10) returns 1  
 
 
SIN (numeric_exp)

The sin function returns the sine of a number.

Example:
SIN(3) returns 0.141120008059867  
 
 
SQR (numeric_exp)

Returns the square of a number.

Example:
SQR(3) returns 9  
 
 
SQRT (numeric_exp)

The sqrt function returns the square root of a number.

Example:
SQRT(9) returns 3  
 
 

        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Jan 17, 2017