LOG2() : natural logarithm of X with base 2

SELECT LOG2(7); // Output is 2.8073549220576
SELECT LOG2(0.1); // Output is -3.32192809488736
SELECT LOG2(0); // Output is NULL

Using ROUND() with LOG()

SELECT ROUND(LOG2(8),2);// Output is 3.00
SELECT ROUND(LOG2(-5),2); // Output is NULL
SELECT ROUND(LOG2(9),2); // Output is 3.17

SELECT LOG2( X )

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here