Numeric Functions

Numeric Function	Comments
ABS	ABS
ACOS	ACOS
ASIN	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
CBRT	Returns the cubic root of a given number.
CEILING	CEILING
COS	Input argument is in radians. See COS
COSH	COSH
COT	Input argument is in radians. See COT
DECFLOAT	DECFLOAT
DEGREES	DEGREES
E	E
EXP	See EXP
FLOOR	See FLOOR
GEO DISTANCE	GEO.DISTANCE
GEO INTERSECTS	GEO.INTERSECTS
GEO LENGTH	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
MOD	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	NEGATIVE
NORMALIZE_DECFLOAT	NORMALIZE_DECFLOAT
NUMERIC_LOG	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	PI
POW	POW
POWER	POWER
QUANTIZE	QUANTIZE
RADIANS	RADIANS
RAND	RAND
RANDOM	Returns a pseudo-random FLOAT value that is greater than 0 but less than 1. See RANDOM
ROUND	See ROUND (for date/time) and ROUND (for numbers)
ROWNUM	ROWNUM
SIGN	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	TOTALORDER