LOG10 - Query language in Cosmos DB (in Azure and Fabric)

The LOG10 function returns the base-10 logarithm of the specified numeric expression.

An Azure Cosmos DB system function that returns the base-10 logarithm of the specified numeric expression.

Syntax

LOG10(<numeric_expr>)

Arguments

	Description
numeric_expr	A numeric expression.

Return types

Returns a numeric expression.

Examples

This section contains examples of how to use this query language construct.

Get base-10 logarithm of values

In this example, the LOG10 function is used to return the logarithm value of various values.

SELECT VALUE {
  logFiveBaseTen: LOG10(5),
  logTwoBaseTen: LOG10(2),
  logHundredBaseTen: LOG10(100)
}

[
  {
    "logFiveBaseTen": 0.6989700043360189,
    "logTwoBaseTen": 0.3010299956639812,
    "logHundredBaseTen": 2
  }
]

Remarks

• This function doesn't utilize the index.