SQL Guide : Functions : Numeric functions
  
Numeric functions
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: 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 from numeric degrees to radians
ROUND(numeric, integer)
Numeric rounded 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)
Numeric truncated to integer
See also
Functions