Returns the base-10 logarithm of a number.

Syntax

LOG10(expression)

Arguments

expression: a positive number of type DOUBLE.

Returns

Returns a DOUBLE value. Returns NULL when expression is NULL.

Examples

SELECT numberCol, LOG10(numberCol) AS numberColLOG10 FROM MYSQL.inventory.cust;

-- LOG10(50);
-- Returns 1.69897000433602