log10 function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the logarithm of expr with base 10.

Syntax

log10(expr)

Arguments

  • expr: An expression that evaluates to a numeric.

Returns

A DOUBLE.

If expr is less than or equal to 0 the result is NULL.

Examples

> SELECT log10(10);
 1.0