SQL math functions

The InfluxDB SQL implementation supports the following math functions for performing mathematic operations:

• abs
• acos
• asin
• atan
• atan2
• ceil
• cos
• exp
• floor
• ln
• log10
• log2
• power
• random
• round
• signum
• sin
• sqrt
• tan
• trunc

abs

Returns the absolute value of a number.

abs(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT abs(temp) AS abs FROM home LIMIT 3

acos

Returns the arc cosine or inverse cosine of a number.

acos(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT acos(temp * .01) AS acos FROM home LIMIT 3

asin

Returns the arc sine or inverse sine of a number.

asin(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT asin(temp * .01) AS asin FROM home LIMIT 3

atan

Returns the arc tangent or inverse tangent of a number.

atan(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT atan(temp * .01) AS atan FROM home LIMIT 3

atan2

Returns the arc tangent or inverse tangent of expression_y / expression_x.

atan2(expression_y / expression_x)

Arguments

• expression_y: First numeric column or literal value to operate on.
• expression_x: Second numeric column or literal value to operate on.

SELECT atan2(temp, hum) AS atan2 FROM home LIMIT 3

ceil

Returns the nearest integer greater than or equal to a number.

ceil(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT ceil(temp) AS ceil FROM home LIMIT 3

cos

Returns the cosine of a number.

cos(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT cos(temp) AS cos FROM home LIMIT 3

exp

Returns the base-e exponential of a number.

exp(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to use as the exponent.

SELECT exp(temp) AS exp FROM home LIMIT 3

floor

Returns the nearest integer less than or equal to a number.

floor(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT floor(temp) AS floor FROM home LIMIT 3

ln

Returns the natural logarithm of a number.

ln(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT ln(temp) AS ln FROM home LIMIT 3

log10

Returns the base-10 logarithm of a number.

log10(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT log10(temp) AS log10 FROM home LIMIT 3

log2

Returns the base-2 logarithm or a number.

log2(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT log2(temp) AS log2 FROM home LIMIT 3

power

Returns a base number raised to the power of an exponent.

power(base, exponent)

Arguments

• power: Base numeric column or literal value to operate on.
• exponent: Exponent numeric column or literal value to operate on.

SELECT power(temp, hum * .1) AS power FROM home LIMIT 3

random

Returns a random float value between 0 and 1. The random seed is unique to each row.

random()

SELECT temp * random() AS random FROM home LIMIT 3

round

Rounds a number to the nearest integer.

round(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT round(temp) AS round FROM home LIMIT 3

signum

Returns the sign of a number. Negative numbers return -1. Zero and positive numbers return 1.

signum(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT signum(temp - 23) AS signum FROM home LIMIT 3

sin

Returns the sine of a number.

sin(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT sin(temp) AS sin FROM home LIMIT 3

sqrt

Returns the square root of a number.

sqrt(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT sqrt(temp) AS sqrt FROM home LIMIT 3

tan

Returns the tangent of a number.

tan(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT tan(temp) AS tan FROM home LIMIT 3

trunc

Truncates a number toward zero (at the decimal point).

trunc(numeric_expression)

Arguments

• numeric_expression: Numeric column or literal value to operate on.

SELECT trunc(temp) AS trunc FROM home LIMIT 3