SIGN returns a DOUBLE PRECISION value of -1, 0, or 1 representing the arithmetic sign of the argument.
Syntax
SIGN ( expression )
Semantics
expression
is an expression of type DOUBLE PRECISION
Examples
SIGN(-8.4)
Result: -1
-1
