Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SIGN

This function returns 1 if the argument is positive, -1 if it is negative, and 0 if it is 0.

Syntax

SIGN ( expression )

Arguments

  • expression: any valid numeric expression.

Return Type

Integer.

Examples

SELECT SIGN(6), SIGN(-6), SIGN(0);
+---------+----------+---------+
| SIGN(6) | SIGN(-6) | SIGN(0) |
+---------+----------+---------+
|       1 |       -1 |       0 |
+---------+----------+---------+