You can use arithmetic operators to perform calculations on values of data types that are supported by PolarDB. This topic describes the arithmetic operators that are supported by PolarDB-O.

The following table describes available arithmetic operators.

Operator Description Example Result
+ Addition. 2 + 3 5
- Subtraction. 2 - 3 -1
* Multiplication. 2 * 3 6
/ Division. Integer division truncates the result. 4 / 2 2
** Exponentiation. 2 ** 3 8