Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the negated value of expr
. This function is a synonym for negative
function.
- expr
expr
: An expression that evaluates to a numeric or interval.
The result type matches the argument type.
For integral numeric types the function can return 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.
> SELECT -(1);
-1
> SELECT -(cast(-32768 AS smallint));
Error: ARITHMETIC_OVERFLOW
> SELECT -INTERVAL '5' MONTH;
-0-5