SQL Server LOG() Function

Return the natural logarithm of 2:

The LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base. From SQL Server 2012, you can also change the base of the logarithm to another value by using the optional base parameter.

Also look at the EXP() function.

number, base ) -- Syntax for SQL Server

number ) -- Syntax for Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Optional. The base the natural logarithm is to be calculated with. Must be greater than 1

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

Return the natural logarithm of 2 to a specified base (4):

❮ SQL Server Functions