LOG2() function

Returns natural logarithm of X with base 2. When X is less than or equal to 0.0E0 we get NULL as output.
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


* indicates required
Subscribe to plus2net


    Post your comments , suggestion , error , requirements etc here .

    SQL Video Tutorials

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2022 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer