Numeric Functions
Numeric functions return absolute values, trigonometric values, the value of pi, and so on.
TDV supports the numeric functions listed in the table.
|
Numeric Function |
Comments |
|
ABS |
|
|
ACOS |
|
|
ASIN |
|
|
ATAN |
Output value is in radians. See ATAN |
|
ATAN2 |
Two-argument version of ATAN. This enables the function to use the sign of x and y to determine the quadrant of the result. See ATAN2 |
|
Returns the cubic root of a given number. |
|
|
CEILING |
|
|
COS |
Input argument is in radians. See COS |
|
COSH |
|
|
COT |
Input argument is in radians. See COT |
|
DECFLOAT |
|
|
DEGREES |
|
|
E |
|
|
EXP |
See EXP |
|
FLOOR |
See FLOOR |
|
GEO DISTANCE |
|
|
GEO INTERSECTS |
|
|
GEO LENGTH |
|
|
LN |
Returns the natural log (base e) of a number. If you need the base 10 of a number, use the LOG function instead. See LN |
|
LOG |
Returns the base 10 of a number. See LOG If you need the base 2 (natural) number instead, use the LN function. |
|
LOG10 |
Returns the log (base 10) of a number. See LOG10 |
|
Modulo. Returns the remainder after dividing the first number by the second number. For example, 18 modulo 12 is 6 (18/12 = 1 with remainder 6, the result). See MOD |
|
|
NEGATIVE |
|
|
NORMALIZE_DECFLOAT |
|
|
Same as LOG. |
|
|
Oracle ROWNUM |
A number indicating the order in which Oracle selects the row from a table or set of joined rows. ROWNUM=1 for of the first row selected, ROWNUM=2 for the second row selected, and so on. |
|
PI |
|
|
POWER |
|
|
QUANTIZE |
|
|
RADIANS |
|
|
RAND |
|
|
RANDOM |
Returns a pseudo-random FLOAT value that is greater than 0 but less than 1. See RANDOM |
|
ROUND |
|
|
ROWNUM |
|
|
Returns the positive or negative sign of the input expression, or 0 if the input expression resolves to zero. See SIGN |
|
|
SIN |
Input argument is in radians. See SIN |
|
SINH |
See SINH |
|
SQRT |
See SQRT |
|
TAN |
Input argument is in radians. See TAN |
|
TANH |
See TANH |
|
TOTALORDER |