LOG10(): log of x with base 10

SELECT LOG10(3); // Output is 0.477121254719662
SELECT LOG10(0.1); // Output is -1
SELECT LOG10(0); // Output is NULL

Using ROUND() with LOG()

SELECT ROUND(LOG10(2),2);// Output is 0.30
SELECT ROUND(LOG10(-2),2); // Output is NULL
SELECT ROUND(LOG10(7),2); // Output is 0.85
Returns natural logarithm of X with base 10. When X is less than or equal to 0.0E0 we get NULL as output.

SQL Math References LOG10() LOG()
Subscribe to our YouTube Channel here


* 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-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer