positive function

Applies to: Databricks SQL Databricks Runtime

Returns the value of expr. This function is a synonym for + (plus sign) unary operator.

positive(expr)

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

The result type matches the argument.

This function is a no-op.

> SELECT positive(1);
 1
> SELECT positive(-1);
 -1

• negative function
• abs function
• sign function
• + (plus sign) unary operator
• - (minus sign) unary operator