LOG10()

The LOG10() SQL function calculates the base-10 logarithm of a number.

Syntax

LOG10(number)

The LOG10() function takes one required parameter, number:

• A float type number greater than 0.
• An expression resulting in a float type number (e.g. EXP(10) or 10*10).

The LOG10() function returns the base-10 logarithm of number as a float.

Note: The LOG10() function is compatible with various SQL database systems such as MySQL, PostgreSQL, SQL Server and Oracle.

Example

The table below, called POWER_OF_TEN, contains powers of 10:

The LOG10() function can calculate the base-10 logarithm of each number in the POWER_OF_TEN table:

SELECT num_id, LOG10(num_10) AS num_log10
FROM POWER_OF_TEN;

The above example results in the following output: