Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

LOG (Transact-SQL)

Returns the natural logarithm of the specified float expression.

Topic link icon Transact-SQL Syntax Conventions


LOG ( float_expression )

float_expression

Is an expression of type float or of a type that can be implicitly converted to float.

The constant e (2.71828182845905…) is the base of natural logarithms.

The base of natural logarithms is the constant e (2.71828182845905…). LOG ( e ) = 1.0.

The natural logarithm of the exponential of a number is the number itself: LOG( EXP( n ) ) = n. And the exponential of the natural logarithm of a number is the number itself: EXP( LOG( n ) ) = n.

A. Calculating the logarithm for a number.

The following example calculates the LOG for the specified float expression.

DECLARE @var float
SET @var = 10
SELECT 'The LOG of the variable is: ' + CONVERT(varchar, LOG(@var))
GO

Here is the result set.

-------------------------------------
The LOG of the variable is: 2.30259

(1 row(s) affected)

B. Calculating the logarithm of the exponent of a number.

The following example calculates the LOG for the exponent of a number.

SELECT LOG (EXP (10))

Here is the result set.

----------------------------------
10
(1 row(s) affected)

Community Additions

ADD
Show:
© 2015 Microsoft