Switch to: V9V8V7V6V5

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