ES|QL SIGNUM function

×

number

Numeric expression. If null, the function returns null.

Returns the sign of the given number. It returns -1 for negative numbers, 0 for 0 and 1 for positive numbers.

ROW d = 100.0
| EVAL s = SIGNUM(d)