LOG10

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

Syntax

LOG10 ( number )

number

A  DOUBLE PRECISION number that is greater than zero (0).

Results

The data type of the returned value is a  DOUBLE PRECISION number.

  • If the specified number is NULL, the result of this function is NULL.
  • If the specified number is zero or a negative number, an exception is returned that indicates that the value is out of range (SQL state 22003).

Example

splice> VALUES LOG10(84.4);
1
----------
1.926342446625655

1 row selected

See Also