LOG10

The LOG10 function returns the common logarithm (base 10) of a number.


>>-LOG10(numeric-expression)-----------------------------------><

The schema is SYSIBM.

The argument is an expression that returns the value of any built-in numeric data type that is not DECFLOAT. If the argument is not a double precision floating-point number, it is converted to one for processing by the function.

The result of the function is a double precision floating-point number.

The result can be null; if the argument is null, the result is the null value.

Example: Assume that host variable HLOG is an INTEGER with a value of 100. The following statement returns a double precision floating-point number with an approximate value of 2:

   SELECT LOG10(:HLOG)
     FROM SYSIBM.SYSDUMMY1;