SIGN()

All functions > MATH > SIGN()

Returns the sign of a number: -1 for negative, 0 for zero, 1 for positive.

Signatures

Sign

Returns: Sign indicator: -1, 0, or 1

SIGN(number: T) → BIGINT

With:

• T : Any numeric type

Signature notes:

• Returns -1 for negative numbers, 0 for zero, 1 for positive numbers
• Returns NULL if the input is NULL

Examples

SELECT
    -- Negative returns -1
    f1 := SIGN(-10.5e0),
    -- Zero returns 0
    f2 := SIGN(0.0e0),
    -- Positive returns 1
    f3 := SIGN(42.7e0),
    -- Integer input
    f4 := SIGN(-5)
;