positive function

Applies to: Databricks SQL Databricks Runtime

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

Syntax

positive(expr)

Arguments

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

Returns

The result type matches the argument.

This function is a no-op.

Examples

SQL

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

Related functions

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