Skip to main content

SIGN

Returns the sign of the argument as -1, 0, or 1, depending on whether X is negative, zero, or positive or NULL if the argument was NULL.

Syntax​

SIGN(X)

Arguments​

ArgumentsDescription
XThe numerical value.

Return Type​

A i8 data type value.

Examples​

SELECT SIGN(NULL);
+------------+
| SIGN(NULL) |
+------------+
|       NULL |
+------------+

SELECT SIGN(0);
+---------+
| SIGN(0) |
+---------+
|       0 |
+---------+

SELECT SIGN(10);
+----------+
| SIGN(10) |
+----------+
|        1 |
+----------+

SELECT SIGN(-10);
+--------------+
| SIGN((- 10)) |
+--------------+
|           -1 |
+--------------+