แก้ไข

แชร์ผ่าน

LOG10 (NoSQL query)

  • บทความ

APPLIES TO: NoSQL

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

The following example returns 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 use the index.
  • The LOG10 and POWER functions are inversely related to one another.

Related content