On this page

    Categories: Math

    SIGN

    Returns the sign of the input expression.

    Syntax

    SIGN(numeric_expression double) → int

    • numeric_expression: Input expression.

    Examples

    SELECT SIGN(10.3)
    -- 1
    

    SIGN(numeric_expression int32) → int32

    • numeric_expression: Input expression.

    Examples

    SELECT SIGN(-5)
    -- -1
    

    SIGN(numeric_expression int64) → int64

    • numeric_expression: Input expression.

    Examples

    SELECT SIGN(24)
    -- 1
    

    SIGN(numeric_expression float) → int

    • numeric_expression: Input expression.

    Examples

    SELECT SIGN(0.0)
    -- 0
    

    Usage Notes

    1 is returned if the input expression is positive. -1 is returned if the input expression is negative. 0 is returned if the input expression is 0.