Jump to: navigation, search

Mysql LN

From w3cyberlearnings

Contents

MySQL LN Function

This function calculates the natural logarithm of X, the base-e logrithnm of X. When X is less than or equal to 0, this function returns NULL.

Syntax LN

X is a number.

LN(X);

Example 1

mysql> SELECT LN(3);
+------------------+
| LN(3)            |
+------------------+
| 1.09861228866811 |
+------------------+
1 row in set (0.00 sec)

Example 2

mysql> SELECT LN(90);
+------------------+
| LN(90)           |
+------------------+
| 4.49980967033027 |
+------------------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References