Skip to content
Related Articles

Related Articles

Improve Article

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
Recommended Articles
Page :