TechNet
• Products
• IT Resources
• Training
• Support

# LOG (Transact-SQL)

SQL Server 2008 R2

Returns the natural logarithm of the specified float expression.

## Syntax

```
LOG ( float_expression )
```

## Arguments

float_expression

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

float

## Remarks

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.

## Examples

### 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)
```