+ (plus sign) unary operator (Databricks SQL)

Returns the value of expr.

Syntax

+ 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.

+ is a synonym for positive function (Databricks SQL).

Examples

> SELECT +(1);
 1

> SELECT +(-1);
 -1

> SELECT +INTERVAL '5' MONTH;
 0-5