sql functions with examples

SQL USER_NAME Function

Return the database user name (will return the current user since no id is specified):

SELECT USER_NAME();

The USER_NAME() function returns the database user name based on the specified id.

If no id is specified, this function will return the name of the current user.

USER_NAME(id_number)

Return the base-10 logarithm of 2:

SELECT LOG10(2);

The LOG10() function returns the natural logarithm of a number to base 10.

Note: Also look at the LOG() function.

LOG10(number)