Negate
The negate operator ( - ) returns the negative value of an operand. Negate is a unary operator: it acts on a single operand.
INTERVAL Type
INTERVAL can be negated in various ways, as shown in the following examples:
- INTERVAL '1' DAY
INTERVAL '-1' DAY
INTERVAL -'1' DAY
Other Data Types
Negate can be applied to the following data types: BIGINT, DECIMAL, FLOAT, INTEGER, INTERVAL, NULL, NUMERIC, REAL, SMALLINT, STRING, and TINYINT.
Negate does not change the operand’s data type.