math::abs

The math::abs function returns the absolute value of a number.

math::abs(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::abs(13.746189);

13

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::abs("13.746189");

13

math::ceil

The math::ceil function rounds a number up to the next largest integer.

math::ceil(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::ceil(13.146572);

14

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::ceil("13.146572");

14

math::fixed

The math::fixed function returns a number with the specified number of decimal places.

math::fixed(number, number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::fixed(13.146572, 2);

13.15

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::fixed("13.146572", 2);

13.15

math::floor

The math::floor function rounds a number down to the next largest integer.

math::floor(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::floor(13.746189);

13

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::floor("13.746189");

13

math::max

The math::max function returns the maximum number in a set of numbers.

math::max(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::max([26.164, 13.746189, 23, 16.4, 41.42]);

41.42

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::max(["26.164", 13.746189, '23', 16.4, "41.42"]);

41.42

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::max("some invalid argument");

null

math::mean

The math::mean function returns the mean of a set of numbers.

math::mean(array) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::mean([26.164, 13.746189, 23, 16.4, 41.42]);

24.1460378

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::mean(["26.164", 13.746189, '23', 16.4, "41.42"]);

24.1460378

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::mean("some invalid argument");

null

math::median

The math::median function returns the median of a set of numbers.

math::median(array) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::median([26.164, 13.746189, 23, 16.4, 41.42]);

23

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::median(["26.164", 13.746189, '23', 16.4, "41.42"]);

23

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::median("some invalid argument");

null

math::min

The math::min function returns the minimum number in a set of numbers.

math::min(array) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::min([26.164, 13.746189, 23, 16.4, 41.42]);

13.746189

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::min(["26.164", 13.746189, '23', 16.4, "41.42"]);

13.746189

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::min("some invalid argument");

null

math::product

The math::product function returns the product of a set of numbers.

math::product(array) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::product([26.164, 13.746189, 23, 16.4, 41.42]);

5619119.004884841504

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::product(["26.164", 13.746189, '23', 16.4, "41.42"]);

5619119.004884841504

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::product("some invalid argument");

null

math::round

The math::round function rounds a number up or down to the nearest integer.

math::round(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::round(13.53124);

14

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::round("13.53124");

14

math::sqrt

The math::sqrt function returns the square root of a number.

math::sqrt(number) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::sqrt(15);

3.872983346207417

If the argument is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::sqrt("15");

3.872983346207417

math::sum

The math::sum function returns the total sum of a set of numbers.

math::sum(array) -> number

The following example shows this function, and its output, when used in a select statement:

SELECT * FROM math::sum([26.164, 13.746189, 23, 16.4, 41.42]);

120.730189

If any value in the array is not a number, then it will be cast to a number before the function is run:

SELECT * FROM math::sum(["26.164", 13.746189, '23', 16.4, "41.42"]);

120.730189

If the argument is not an array, then an EMPTY value will be returned:

SELECT * FROM math::sum("some invalid argument");

null