Outdated Version
You are viewing an older version of this section. View current production version.
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 |
+---------+----------+---------+
