LN function [Numeric]

Function

Returns the natural logarithm of the specified expression.

Syntax

LNnumeric-expression )

Parameters

expression Is a column, variable, or expression with a data type that is either exact numeric, approximate numeric, money, or any type that can be implicitly converted to one of these types. For other data types, the LN function generates an error. The return value is of DOUBLE data type.

Usage

LN takes one argument. For example, LN (20) returns 2.995732.

The LN function is an alias of the LOG function.

Standards and compatibility

See also

“LOG function [Numeric]”

Chapter 11, “International Languages and Character Sets” in the System Administration Guide: Volume 1