**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]
Sidebar
minus
Table of Contents
Subtraction Operator (-) PL/HQL
You can use (-) arithmetic operator to subtract two numbers, or subtract the number of days from a DATE value.
Syntax:
expr - expr
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 |
Page Tools
