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. | DOUBLE PRECISION |
Return Type
DOUBLE PRECISION
Examples
The following examples highlight what can be returned with the SIGN function: | 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