This page describes the available functions to assist with performing numeric calculations.

abs

abs(value) return the absolute value. The behavior of abs is as follows:

• When the input value is positive, abs returns value
• When the input value is negative, abs returns - value
• When the input value is 0, abs returns 0

Arguments:

• value is any numeric value.

Return value:

Return value type is double.

Examples:

SELECT
    x - 2 a,
    abs(x -2)
FROM long_sequence(3);

log

log(value) return the natural logarithm (loge) of a given number.

Arguments:

• value is any numeric value.

Return value:

Return value type is double.

Examples:

SELECT log(4.123)

round

round(value, scale) returns the closest value in the specified scale. It uses the “half up” tie-breaking method when the value is exactly halfway between the round_up and round_down values.

Arguments:

• value is any numeric value.
• scale is the number of decimal points returned. A negative scale means the rounding will occur to a digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens and +1 to the nearest tenths.

Return value:

Return value type is double.

Examples:

SELECT
    d,
    round(d, -2),
    round(d, -1),
    round(d,0),
    round(d,1),
    round(d,2)
FROM dbl;

round_down

round_down(value, scale) - rounds a value down to the specified scale

Arguments:

• value is any numeric value.
• scale is the number of decimal points returned. A negative scale means the rounding will occur to a digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens and +1 to the nearest tenths.

Return value:

Return value type is double.

Examples:

SELECT
    d,
    round_down(d, -2),
    round_down(d, -1),
    round_down(d,0),
    round_down(d,1),
    round_down(d,2)
FROM dbl;

round_half_even

round_half_even(value, scale) - returns the closest value in the specified scale. It uses the “half up” tie-breaking method when the value is exactly halfway between the round_up and round_down values.

Arguments:

• value is any numeric value.
• scale is the number of decimal points returned. A negative scale means the rounding will occur to a digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens and +1 to the nearest tenths.

Return value:

Return value type is double.

Examples:

SELECT
    round_half_even(5.55, 1),
    round_half_even(5.65, 1)
FROM long_sequence(1);

SELECT
    d,
    round_half_even(d, -2),
    round_half_even(d, -1),
    round_half_even(d,0),
    round_half_even(d,1),
    round_half_even(d,2)
FROM dbl;

round_up

round_up(value, scale) - rounds a value up to the specified scale

Arguments:

• value is any numeric value.
• scale is the number of decimal points returned. A negative scale means the rounding will occur to a digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens and +1 to the nearest tenths.

Return value:

Return value type is double.

Examples:

SELECT
    d,
    round_up(d, -2),
    round_up(d, -1),
    round_up(d,0),
    round_up(d,1),
    round_up(d,2)
FROM dbl;

sqrt

sqrt(value) return the square root of a given number.

Arguments:

• value is any numeric value.

Return value:

Return value type is double.

Examples:

SELECT sqrt(4000.32)