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