Usage:
intDiv(a, b)Divide a by b, rounding the answer down to the nearest whole number.
Usage:
log(<expression>)log returns the natural logarithm of a provided number. ln is also available as an alias.
Examples:
-- get the natural logarithm of the double1 column
log(double1)Usage:
pow(<expression>, <expression>)pow returns the first argument raised to the power of the second argument.
Examples:
-- get the square of the double1 column
pow(double1, 2)Usage:
round(<expression>[, n])round returns a number rounded to the nearest whole number, or to a given number of decimal points specified by the second argument.
Examples:
-- round 5.5 to 6
round(5.5)
-- round 3.14 to 3.1
round(3.14, 1)Usage:
floor(<expression>[, n])floor returns a number rounded down to a whole number, or rounded down to a given number of decimal points specified by the second argument.
Examples:
-- round down 5.5 to 5
floor(5.5)
-- round down 3.14 to 3.1
floor(3.14, 1)Usage:
ceil(<expression>[, n])ceil returns a number rounded up to a whole number, or rounded up to a given number of decimal points specified by the second argument.
Examples:
-- round up 5.5 to 6
ceil(5.5)
-- round up 3.14 to 3.2
ceil(3.14, 1)