Arithmetic operators
Arithmetic operators are used to generate numeric output from one or more input expressions.
The input expressions must be numeric (integer or floating point), except in the following cases:
- The binary operator
+and-can be applied for datetime calculations:<timestamp>+<interval>returns a<timestamp><timestamp>-<interval>returns a<timestamp><timestamp>-<timestamp>returns a<interval>
List of arithmetic operators
| Operator | Syntax | Description |
|---|---|---|
- (unary) | -a | Negates the input numeric expression. |
+ | a + b | Adds two numeric expressions (a and b). |
- | a - b | Subtracts one numeric expression (b) from another (a). |
* | a * b | Multiplies two numeric expressions (a and b). |
/ | a / b | Divides one numeric expression (a) by another (b). Divide by 0 returns infinity. |
% | a % b | Computes the modulo of numeric expression a by b. |