# DEGREES(), DIV() and EXP() Function in MariaDB

• Last Updated : 13 Oct, 2020

1. DEGREES() Function :
In MariaDB, The DEGREES Function converts a radian value into degrees. In this function, a number will be passed as a parameter and it will return a degree of the radian value.

Syntax :

`DEGREES(number)`

Parameter : Required. A value in Radians.
number : Value in radians that is to be converted to degrees.
Returns : Degree equivalent of the value input in radians.

Example-1 :

`SELECT DEGREES(-3.5);`

Output :

`-200.53522829578813`

Example-2 :

`SELECT DEGREES(PI()*3);`

Output :

`540`

Example-3 :

`SELECT DEGREES(1);`

Output :

`57.29577951308232`

2. DIV() Function :
In MariaDB, The DIV Function used for integer division where n is divided by m and integer value is returned. In this function, two numbers will be passed as a parameter and it will return the result as an integer value. It can also be used with BIGINT values.

Syntax :

`n DIV m`

Parameters : Required. Two integer values.

• n : Divident (Value that will be divided).
• m : Divisor (Value which the dividend is being divided by).

Returns : An integer value as the result of the division.

Example-1 :

`SELECT 11 DIV 4;`

Output :

`3`

Example-2 :

`SELECT 18 DIV 9;`

Output :

`2`

Example-3 :

`SELECT 18.4 DIV -2.5;`

Output :

`-7`

3. EXP() Function :
In MariaDB, The EXP Function returns e raised to the power of number (or e^number). In this function, a number will be passed as a parameter and it will return e raised to the power of number. In this function e is the base of natural logarithms.

Syntax :

`EXP(number)`

Parameter : Required. A numeral value.
number : Power to raise e to, so the formula would be e^number.
Returns : e raised to the power of the input number.

Example-1 :

`SELECT EXP(2);`

Output :

`7.38905609893065`

Example-2 :

`SELECT EXP(2.5);`

Output :

`12.182493960703473`

Example-3 :

`SELECT EXP(-2.5);`

Output :

`0.0820849986238988`
My Personal Notes arrow_drop_up