LOG10 (Transact-SQL)
SQL Server 2005
Returns the base-10 logarithm of the specified float expression.
Transact-SQL Syntax Conventions
- float_expression
-
Is an expression of type float or of a type that can be implicitly converted to float.
A. Calculating the base 10 logarithm for a variable.
The following example calculates the LOG10 of the specified variable.
DECLARE @var float SET @var = 145.175643 SELECT 'The LOG10 of the variable is: ' + CONVERT(varchar,LOG10(@var)) GO
Here is the result set.
The LOG10 of the variable is: 2.16189 (1 row(s) affected)
B. Calculating the result of raising a base-10 logarithm to a specified power.
The following example returns the result of raising a base-10 logarithm to a specified power.
SELECT POWER (10, LOG10(5))
Here is the result set.
----------- 5 (1 row(s) affected)
Reference
Mathematical Functions (Transact-SQL)POWER (Transact-SQL)
LOG (Transact-SQL)
