log

Description

Returns the natural logarithm of the specified number.

Syntax

log(approx_numeric)

Parameters

approx_numeric

is any approximate numeric (float, real, or double precision) column name, variable, or constant expression.

Examples

Example 1

select log(20)

-------------------- 
             2.995732

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute log.

See also

Functions log10, power