SQL Server LOG10() Function

Return the base-10 logarithm of 2:

SELECT LOG10(2);

Definition and Usage

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

Note: Also look at the LOG() function.

LOG10(number)

Parameter	Description
number	Required. A number greater than 0

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Return the base-10 logarithm of 4.5:

SELECT LOG10(4.5);