Syntax

 

<natural logarithm> ::=

 

 

 

LN ( <numeric value expression> )

 

 

Notes

 

The LN function returns the natural logarithm of the argument.



 

The argument shall be greater than 0.



 

The data type of the result is DOUBLE PRECISION.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

LN( 2 )

0.693147..

LN( 7.5 )

2.014903..

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"