The LOG10 function returns the common logarithm (base 10) of a number. The LOG10 and ANTILOG functions are inverse operations.
If the data type of the argument is DECFLOAT(n), the result is DECFLOAT(n). Otherwise, 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.
Results involving
DECFLOAT special values: For decimal floating-point values the
special values are treated as follows:
Syntax alternatives: LOG is a synonym for LOG10. It is supported only for compatibility with previous DB2® 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.