LN() function :
It is the function in SQL is used to calculate the natural logarithm of a specific number with base e . The number must be greater than 0, otherwise it will return NULL.
Syntax :
LN(X)
Parameter :
LN() function accepts one parameter as mentioned above in the syntax and described below as follows.
X – A number whose logarithm value with base e we want to calculate. It should be a positive number.
Returns :
It returns the natural logarithm of given number x with base e.
Example:
The logarithm of the given number with base e using the LN() function.
SELECT LN(1000) AS Ln_Val ;
Output :
LN_VAL
6.90775527898