Function |
Description |
ABS (numeric_exp) |
Absolute value. |
ACOS (float_exp) |
Arc cosine as an angle expressed in radians |
ASIN (float_exp) |
Arc sine as an angle expressed in radians |
ATAN (float_exp) |
Arc tangent as an angle expressed in radians |
ATAN2 (float_exp1, float_exp2) |
Arc tangent of the x- and y-coordinates specified by float_exp1 and float_exp2 as an angle expressed in radians |
CEILING (numeric_exp) |
Smallest integer greater than or equal to numeric_exp. |
COS (float_exp) |
The cosine of float_exp where float_exp is an angle expressed in radians. |
COT (float_exp) |
The cotangent of float_exp where float_exp is an angle expressed in radians. |
DEGREES (numeric_exp) |
Converts to the number of degrees where numeric_exp is an angle expressed in radians. |
EXP (float_exp) |
Exponential value of float_exp |
FLOOR (numeric_exp) |
Largest integer less than or equal to numeric_exp. |
LOG (float_exp) |
Natural logarithm of float_exp. |
LOG10 (float_exp) |
Base 10 logarithm of float_exp. |
MOD (integer_exp1, integer_exp2) |
Remainder (modulus) of integer_exp1 divided by integer_exp2. |
PI () |
Constant value of pi. |
POWER (numeric_exp, integer_exp) |
Numeric_exp to the power of integer_exp. |
RADIANS (numeric_exp) |
Converts to the number of radians where numeric_exp is an angle expressed in degrees. |
RAND ([integer_exp]) |
Random number using the optional integer_exp as seed value. |
ROUND (numeric_exp, integer_exp) |
Numeric_exp rounded to integer_exp positions right of the decimal separator. |
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 is zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned. |
SIN (float_exp) |
The sine of float_exp where float_exp is an angle expressed in radians. |
SQRT (float_exp) |
Square root of float_exp. |
TAN (float-exp) |
The tangent of float_exp where float_exp is an angle expressed in radians. |
TRUNCATE (numeric_exp, integer_exp) |
Numeric_exp truncated to integer_exp positions right of the decimal separator. |
Time, Date and Interval Functions
Data Type Conversion Functions