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.
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.
It returns the natural logarithm of given number x with base e.
The logarithm of the given number with base e using the LN() function.
SELECT LN(1000) AS Ln_Val ;