Skip to main content

Categories: Math

SIGN

Returns the sign of the input expression.

Syntax​

SIGN(numeric_expression double) → int​

  • numeric_expression: Input expression.

Examples

SIGN example 
SELECT SIGN(10.3)
-- 1

SIGN(numeric_expression int32) → int32​

  • numeric_expression: Input expression.

Examples

SIGN example 
SELECT SIGN(-5)
-- -1

SIGN(numeric_expression int64) → int64​

  • numeric_expression: Input expression.

Examples

SIGN example 
SELECT SIGN(24)
-- 1

SIGN(numeric_expression float) → int​

  • numeric_expression: Input expression.

Examples

SIGN example 
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.