LOG() function

Returns natural logarithm of X. We cap add one more argument to specify Base.
X is the number and B is the base. The output is log value of X with base B.

Using ROUND() with LOG()

SELECT ROUND(LOG(2),2);// Ouput is 0.69
SELECT ROUND(LOG(-2),2); // Ouput is NULL
SELECT ROUND(LOG(6,3),2); // Output is 0.61
If Base is less than or equal to 1 then NULL is returned, similarly if X is less than or equal to 0 then NULL is returned.
SELECT LOG( 6, -0.1 ); Output is NULL
SELECT LOG( -6, 2 ); // Output is NULL
SELECT LOG( 6, 0.1 ) // Output is -1.28509720893847


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