The LOG10 function returns the common log value of an antilogarithm x. The return value is a DOUBLE type. If the antilogarithm is 0 or a negative number, an error is returned.
LOG10 ( x )
SELECT log10(1), log10(1000);
log10(1) log10(1000)
====================================================
0.000000000000000e+00 3.000000000000000e+00