Transact-SQL Reference

LOG10

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