- (minus sign) unary operator

Returns the negated value of expr. This function is a synonym for negative function.

Syntax

- expr

Arguments

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

Returns

The result type matches the argument type.

For integral numeric types the function can raise an ARITHMETIC_OVERFLOW error.

warning

In Databricks Runtime, if spark.sql.ansi.enabled is false, an overflow does not cause an error but "wraps" the result instead.

Common error conditions

• ARITHMETIC_OVERFLOW

Examples

SQL

> SELECT -(1);
 -1

> SELECT -(cast(-32768 AS smallint));
 Error: ARITHMETIC_OVERFLOW

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

Related functions

• sign function
• abs function
• positive function
• + (plus sign) unary operator
• negative function