MONTH() Function in SQL Server

LOG10() Function in SQL Server

Last Updated : 29 Sep, 2020

This function returns the logarithm of a number to base 10.

Syntax :

LOG10(number)

Parameter :
This method accepts a single-parameter as mentioned above and described below.

number –
This parameter hold a number which is greater than 0.

Returns –
It returns the base-10 logarithm of the specified number.

Let’s consider the following examples.
Example-1 :

SELECT LOG10(1) Result;

Output :

Result
0

Example-2 :

SELECT LOG10(10) Result;

Output :

Result
1

Example-3 :
Return the base-10 logarithm of 10.

SELECT LOG10(10);

Output :

1.0

Example-4 :
Return the base-10 logarithm of 1.

SELECT LOG10(1);

Output :

0.0

Example-5 :
When the argument passing as an expression.

SELECT LOG10(2 * 3);

Output :

0.77815125038364363

MONTH() Function in SQL Server

sanjoy_62

Improve

Article Tags :

Similar Reads

LOG() Function in SQL Server

The LOG() function returns the logarithm of a specified number or the logarithm of the number to the specified base. Syntax : LOG(number, base) Parameter : LOG() function accepts two-parameters as mentioned above and described below. number - This parameter hold a number which is greater than 0. bas

LOWER() function in SQL Server

LOWER() : This function in SQL Server helps to convert all the letters of the given string to lowercase. If the given string contains characters other than alphabets, then they will remain unchanged by this function. Syntax : LOWER( str ) Parameters : str - The string which will be converted to lowe

PI() Function in SQL Server

PI() function : This function in SQL Server is used to return the constant float value of math Pi. The default number of decimal places displayed is seven, but SQL Server uses the full double-precision value internally. Features : This function is used to get the value of pi.This function does not a

MONTH() Function in SQL Server

MONTH() function : This function in SQL Server is used to return the month of the year i.e, from 1 to 12 for a date stated. Features : This function is used to find the month of the year for a date specified. This function comes under Date Functions. This function accepts only one parameter i.e, dat

LTRIM() Function in SQL Server

The LTRIM() function in SQL Server removes all the space characters found on the left-hand side of the string. It removes the leading spaces from a string, SyntaxThe LTRIM function for SQL Server syntax is: LTRIM(string, [trim_string]) Parameter: string - The string from which the leading space char

MAX() Function in SQL Server

MAX() : This function in SQL Server is used to find the value that is maximum in the group of values stated. Features : This function is used to find the maximum value.This function comes under Numeric Functions.This function accepts only one parameter namely expression. Syntax : MAX(expression) Par

MIN() Function in SQL Server

MIN() : This function in SQL Server is used to find the value that is minimum in the group of values stated. Features : This function is used to find the minimum value.This function comes under Numeric Functions.This function accepts only one parameter namely expression. Syntax : MIN(expression) Par

RANK() Function in SQL Server

The RANK() function is a powerful window function in SQL Server used to assign a rank to each row within a result set. It is particularly useful when we need to assign a rank to a group of rows based on some sorting criteria and want to differentiate between rows that have the same values. Unlike ot

NULLIF() Function in SQL Server

NULLIF() function in SQL Server is used to check if the two specified expressions are equal or not. If two arguments passed to a function are equal, the NULLIF() function returns Null to us. NULLIF() function operates like a Like a CASE Statement. It will return the value of the first argument if th

Scalar Function in SQL Server

Pre-requisites: Categories of SQL Functions In SQL Server, a scalar function is a type of user-defined function that returns a single scalar value based on the input parameters passed to it. The scalar function is used to perform some calculations or operations on the input parameters and return a s