ABS

All functions > MATH > ABS

Returns the absolute value of a number.

Signatures

Returns: The absolute (non-negative) value

ABS(number: T) → T

Notes

• Removes the sign from a number, making it positive
• Returns NULL if the input is NULL
• ABS(0) = 0
• ABS(positive) = positive
• ABS(negative) = positive

Examples

SELECT
    f1 := ABS(-10),  -- Negative integer
    f2 := ABS(5),  -- Positive integer
    f3 := ABS(0),  -- Zero
    f4 := ABS(-3.7e0)  -- Negative decimal
;