SQL numeric functions supported
| Function | Description |
|---|---|
| ABS(numeric_exp) | Returns the absolute value of numeric_exp. |
| ACOS(float_exp) | Returns the arccosine of float_exp as an angle, expressed in radians. |
| ASIN(float_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(float_exp1, float_exp2) | 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 float_exp, where float_exp is an angle expressed in radians. |
| COT(float_exp) | Returns the cotangent of float_exp, where float_exp is an angle expressed in radians. |
| DEGREES(numeric_exp) | Returns the number of degrees converted from numeric_exp radians. |
| EXP(float_exp) | Returns the exponential value of float_exp. |
| FLOOR(numeric_exp) | Returns largest integer less than or equal to numeric_exp. |
| LOG(float_exp) | Returns the natural logarithm of float_exp. |
| LOG10(float_exp) | Returns the base 10 logarithm of float_exp. |
| MOD(integer_exp1, integer_exp2) | Returns the remainder (modulus) of integer_exp1 divided by integer_exp2. |
| PI( ) | Returns the constant value of pi as a floating point value. |
| POWER(numeric_exp, integer_exp) | Returns the value of numeric_exp to the power of integer_exp. |
| RADIANS(numeric_exp) | Returns the number of radians converted from numeric_exp degrees. |
| RAND([integer_exp]) | Returns a random floating point value using integer_exp as the optional seed value. |
| ROUND(numeric_exp, integer_exp) | Returns numeric_exp rounded to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to |integer_exp| places to the left of the decimal point. |
| SIGN(numeric_exp) | Returns an indicator of the sign of 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 float_exp, where float_exp is an angle expressed in radians. |
| SQRT(float_exp) | Returns the square root of float_exp. |
| TAN(float_exp) | Returns the tangent of float_exp, where float_exp is an angle expressed in radians. |
| TRUNCATE(numeric_exp, integer_exp) | Returns numeric_exp truncated to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is truncated to |integer_exp| places to the left of the decimal point. |