LOG10 (T-SQL)

Returns the base-10 logarithm of the given float expression.

Syntax

LOG10(float_expression)

Arguments

float_expression

Is an expression of the float data type.

Return Types

float

Examples

This example calculates the LOG10 of the given 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)

See Also

Mathematical Functions