UNARY_MINUS()

All functions > MATH > UNARY_MINUS()

Negates a numeric expression (unary minus).

Signatures

Returns: Same type as the operand

UNARY_MINUS(expr: T) → T

With:

• T : Any numeric type

Notes

• Written in FeatureQL as a leading - before an expression (for example -AMOUNT).
• NULL in, NULL out.

Examples

SELECT
    -- Function call form
    f1 := UNARY_MINUS(3),
    -- Operator form on integer literal
    f2 := -3,
    -- DOUBLE literal
    f3 := -1.0e0
;