signum function
Applies to: 
Databricks SQL Databricks Runtime
Returns -1.0, 0.0, or 1.0 as expr is negative, 0, or positive. This function is a synonym for sign function.
Syntax
signum(expr)
Arguments
expr: An expression that evaluates to a numeric or interval.
Interval is supported since: Databricks Runtime 10.1)
Returns
A DOUBLE.
Examples
SQL
> SELECT signum(40);
1.0
> SELECT signum(INTERVAL'-1' DAY)
-1.0