Table of Contents
Operators
The usual arithmetic operators are available.
+ Addition
SELECT 3+5; => 8
- Subtraction
SELECT 3-5; => -2
- Unary Minus
Changes the sign of the argument
SELECT - 2; => -2
* Multiplication
SELECT 3*5; => 15
/ Division
SELECT 3/5; => 0.60
Division by zero returns NULL:
SELECT 102/(1-1); => NULL
% Modulo
SELECT 253 % 7; => 1