The LOG10 function returns the common logarithm (base 10) of a number. The LOG10 and ANTILOG functions are inverse operations.
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.
Syntax alternatives: LOG is a synonym for LOG10. It is supported only for compatibility with previous DB2(R) releases. LOG10 should be used instead of LOG because some database managers and applications implement LOG as the natural logarithm of a number instead of the common logarithm of a number.
SELECT LOG10(:L) FROM SYSIBM.SYSDUMMY1Returns the approximate value 1.49.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.