Function
|
Purpose
|
---|---|
ABS(numeric)
|
Absolute value of numeric
|
ACOS(float)
|
Arccosine of float, where float is expressed in radians
|
ASIN(float)
|
Arcsine of float, where float is expressed in radians
|
ATAN(float)
|
Arctangent of float, where float is expressed in radians
|
ATAN2(float1, float2)
|
Arctangent of the x and y coordinates, specified by float1 and float2, respectively, as an angle, expressed in radians
|
CEILING(numeric)
|
Smallest integer greater than or equal to numeric
|
COS(float)
|
Cosine of float, where float is expressed in radians
|
COT(float)
|
Cotangent of float, where float is expressed in radians
|
DEGREES(numeric)
|
Converts numeric radians to degrees
|
DIFFERENCE(str1, str2)
|
Return the value of phonetic difference between str1 and str2: 0 - 4
|
EXP(float)
|
Exponential value of float
|
FLOOR(numeric)
|
Largest integer less than or equal to numeric
|
LOG(float)
|
Natural logarithm of float
|
LOG10(float)
|
Base 10 log of float
|
MOD(integer1, integer2)
|
Modulus of integer1 divided by integer2
|
PI()
|
Pi as a floating point number
|
POWER(numeric, integer)
|
Value of numeric raised to the power of integer
|
RADIANS(numeric)
|
Converts numeric from degrees to radians
|
RAND([integer_exp])
|
Returns random floating-point value by using integer_exp as the optional seed value
|
ROUND(numeric, integer)
|
Rounds numeric to integer
|
SIGN(numeric)
|
Sign of numeric
|
SIN(float)
|
Sine of float, where float is expressed in radians
|
SQRT(float)
|
Square root of float
|
TAN(float)
|
Tangent of float, where float is expressed in radians
|
TRUNCATE(numeric, integer)
|
Truncate numeric to integer
|