minus

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

minus [2015/09/23 20:27]
minus [2015/09/23 20:27] (current)
Line 1: Line 1:
 +====== Subtraction Operator (-) PL/HQL ======
 +
 +You can use (-) arithmetic operator to subtract two numbers, or subtract the number of days from a DATE value.
 +
 +**Syntax:**
 +
 +<​code>​
 +expr - expr
 +</​code>​
 +
 +===== Subtract Two Integers =====
 +
 +When you subtract two integer values the result of the operation also has an integer value.
 +
 +**Example:​**
 +
 +| **Expression** | **Result** | **Result Type** |
 +| 3 - 1 | 2 | Integer |
 +
 +===== Subtract Integer from Date =====
 +
 +When you subtract an integer from a DATE value, PL/HQL subtracts the number of days from the DATE and the result of the operation is a DATE value.
 +
 +**Example:​**
 +
 +| **Expression** | **Result** | **Result Type** |
 +| DATE '​2015-01-01'​ - 1 | DATE '​2014-12-31'​ | DATE |