Syntax
LOGARITHM_10(Argument)
Description
The LOGARITHM_10 SQL scalar function returns the common logarithm (base 10) of a number.
The argument must be a number.
The data type of the result is double-precision floating point.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Example
Assume the column L is a decimal (4,2) column with a value of 31.62.
LOGARITHM_10(L)
Returns the approximate value 1.49.
List of SQL scalar functions by topic