LOG10 Function

Description

The LOG10 function returns the common log value of an antilogarithm x. The return value is a DOUBLE type. If the antilogarithm is 0 or a negative number, an error is returned.

Syntax

LOG10 ( x )

Example

SELECT log10(1), log10(1000);

     log10(1)                  log10(1000)

====================================================

     0.000000000000000e+00     3.000000000000000e+00