Math Numeric Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Math Numeric Functions
  4. LN(X) returns the natural logarithm of X; that is, the base-e logarithm of X
mysql>
mysql> SELECT LN(2);
+------------------+
| LN(2)            |
+------------------+
| 0.69314718055995 |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT LN(-2);
+--------+
| LN(-2) |
+--------+
|   NULL |
+--------+
1 row in set (0.00 sec)
mysql>