Arithmetic - Influxdb

Arithmetic operators take two numeric values (either literals or variables) and perform a calculation that returns a single numeric value.

Operator	Description
`+`	Addition	{{< icon "link" >}}
`-`	Subtraction	{{< icon "link" >}}
`*`	Multiplication	{{< icon "link" >}}
`/`	Division	{{< icon "link" >}}
`%`	Modulo	{{< icon "link" >}}

+ {#addition .monospace}

The + operator adds two operands together and returns the sum.

sql

SELECT 1 + 2

int64(1) + int64(2)
3

- {#subtraction .monospace}

The - operator subtracts the right operand from the left operand and returns the difference.

sql

SELECT 4 - 2

int64(4) - int64(2)
2

* {#multiplication .monospace}

The * operator multiplies two operands together and returns the product.

sql

SELECT 2 * 3

int64(2) * int64(3)
6

/ {#division .monospace}

The / operator divides the left operand by the right operand and returns the quotient.

sql

SELECT 6 / 3

int64(6) / int64(3)
2

% {#modulo .monospace}

The % (modulo) operator divides the left operand by the right operand and returns the remainder. If the left operand is not divisible by the right operand, it returns the left operand.

sql

SELECT 8 % 3

Int64(8) % Int64(3)
2

sql

SELECT 3 % 8

Int64(3) % Int64(8)
3