sign 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 signum function.

sign(expr)

• expr: An expression that evaluates to a numeric or interval.

Interval is supported since: Databricks Runtime 10.1)

A DOUBLE.

> SELECT sign(40);
 1.0

> SELECT sign(INTERVAL'-1' DAY)
 -1.0

• abs function
• signum function
• negative function
• positive function