- [subtraction]

All functions > MATH > - [subtraction]

Subtracts the right-hand value from the left-hand value (numeric, temporal, or interval forms).

Syntax

left - right  ·  SUBTRACT(left, right)

left - right  ·  SUBTRACT(left, right)

Notes

• Numeric subtraction: same-type operands; returns NULL if either operand is NULL
• timestamp - interval / date - interval yield a TIMESTAMP
• timestamp1 - timestamp2 / date1 - date2 yield an INTERVAL
• Order matters: a - b is not the same as b - a

Related Functions

• SUBTRACT()

Examples

- — numeric

SELECT
    f1 := 10 - 3, -- Basic subtraction
    f2 := 10 - (-3) -- Subtracting a negative
;

- — date and time

SELECT
    f1 := TIMESTAMP '2021-01-02' - INTERVAL '1 DAY', -- Timestamp minus interval
    f2 := TIMESTAMP '2021-01-02' - TIMESTAMP '2021-01-01' -- Difference of two timestamps
;

- — floating-point

SELECT
    f1 := 2.5E0 - 1.0E0 -- DOUBLE operands
;