ABS()

All functions > MATH > ABS()

Returns the absolute value of a number.

Signatures

Absolute value

Returns: The absolute (non-negative) value

ABS(number: T) → T

With:

• T : Any numeric type

Signature notes:

• Preserves the input type
• Returns NULL if the input is NULL
• ABS(0) = 0

Examples

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