SQL — Numeric Functions
The table below lists the numeric functions specified in the ODBC 3.51
and JDBC 2.0 specifications that are supported by the BASIS DBMS.
Arguments denoted as numeric_exp can be the name of a column (of any numeric type), the result of another scalar function that returns a numeric value, a mathematical operation, or a numeric literal.
Arguments denoted as float_exp can be the name of a column (of type FLOAT, DOUBLE, REAL, or DECIMAL), the result of another scalar function that returns a float value, a mathematical operation, or a numeric literal.
Arguments denoted as integer_exp can be the name of a column (of type signed or unsigned INTEGER), the result of another scalar function that returns an integer value, a mathematical operation, or an integer literal.
|
Function |
Description |
|
ABS(numeric_exp) |
Returns the absolute value of numeric_exp. |
|
ACOS(numeric_exp) |
Returns the arccosine of float_exp as an angle expressed in radians. |
|
ASIN(numeric_exp) |
Returns the arcsine of float_exp as an angle expressed in radians. |
|
ATAN(float_exp) |
Returns the arctangent of float_exp as an angle expressed in radians. |
|
ATAN2(double,double) |
Returns the arctangent of the x and y coordinates, specified by float_exp1 and float_exp2, respectively, as an angle, expressed in radians. |
|
CEILING(numeric_exp) |
Returns the smallest integer greater than or equal to numeric_exp. |
|
COS(float_exp) |
Returns the cosine of the float_exp as an angle expressed in radians. |
|
COT(numeric_exp) |
Returns the cotangent of numeric_exp as an angle expressed in radians. |
|
DEGREES(numeric_exp) |
Returns the number of degrees converted from numeric_exp radians. |
|
EXP(numeric_exp) |
Returns the exponential value of float_exp. |
|
FLOOR(numeric_exp) |
Returns the largest integer less than or equal to numeric_exp. |
|
LOG(numeric_exp) |
Returns the natural logarithm of float_exp. |
|
LOG10(numeric_exp) |
Returns the base 10 logarithm of float_exp. |
|
In BBj 8.0 and higher, returns the median of a group of numbers. |
|
|
MOD(integer_exp1, integer_exp2) |
Returns the remainder (modulus) of integer_exp1 divided by integer_exp2. |
|
PI() |
The numeric literal
for PI defined as: |
|
POWER(numeric_exp) |
Returns the value of numeric_exp to the power of integer_exp. |
|
RADIANS(numeric_exp) |
Returns the number of radians concerted from numeric_exp degrees. |
|
RAND(numeric_exp) |
Generates a random number using numeric_exp as a seed. |
|
ROUND(numeric_exp, integer_exp) |
Rounds numeric_exp to integer_exp decimal places. |
|
SIGN(numeric_exp) |
If numeric_exp is less than zero, -1 is returned. If numeric_exp equals zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned. |
|
SIN(float_exp) |
Returns the sine of the float_exp as an angle expressed in radians. |
|
SQRT(numeric_exp) |
Returns the square root of numeric_exp. |
|
In BBj 8.0 and higher, returns the standard deviation of a group of numbers. |
|
|
TAN(numeric_exp) |
Returns the tangent of numeric_exp as an angle expressed in radians. |
|
TRUNCATE(numeric_exp) |
Returns numeric_exp with the decimal portion removed. |
Example
Select IFF(SIGN(curr_bal)>=0, '+', '-')+STR(ABS(curr_bal)) from customer