SIGN
Returns the sign of a number according to the table below.
Syntax
SIGN(<value>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
value | Any expression that evaluates to a numeric data type. | INTEGER, NUMERIC, BIGINT, REAL, DOUBLE PRECISION |
Return Types
Same as the input number type (<value>).
Examples
| If | Returns |
|---|---|
<value> < 0 | -1 |
<value> = 0 | 0 |
<value> > 0 | 1 |
SIGN(5)
Returns: 1
SIGN(-1.35E-10)
Returns: -1
SIGN(0)
Returns: 0