solidDB Help : solidDB reference : SQL: Functions : Numeric functions
  
Numeric functions
The purpose of each numeric function is described in the following table:
s
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
Go up to
SQL: Functions