Numeric Functions

This section contains the reference documentation for the Numeric functions built into Splice Machine SQL:

Function Name Description
ABS or ABSVAL Returns the absolute value of a numeric expression.
CEIL or CEILING Round the specified number up, and return the smallest number that is greater than or equal to the specified number.
EXP Returns e raised to the power of the specified number.
FLOOR Rounds the specified number down, and Returns the largest number that is less than or equal to the specified number.
LN or LOG Return the natural logarithm (base e) of the specified number.
LOG10 Returns the base-10 logarithm of the specified number.
MOD Returns the remainder (modulus) of one number divided by another.
RAND Returns a random number given a seed number
RANDOM Returns a random number.
SIGN Returns the sign of the specified number.
SQRT Returns the square root of a floating point number; 
TRUNC or TRUNCATE Truncates numeric, date, and timestamp values.