Syntax
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 theSIGN function:
| If | Returns |
|---|---|
<value> < 0 | -1 |
<value> = 0 | 0 |
<value> > 0 | 1 |
1
Example
-1
Example
0