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 |
+---------+----------+---------+