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.
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.
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.
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.
SELECT 11 DIV 4;
SELECT 18 DIV 9;
SELECT 18.4 DIV -2.5;
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.
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.
- DEGREES() and RADIANS() Function in SQL Server
- Exp() and Count() Function in MS Access
- DEGREES() Function in MySQL
- PLSQL | EXP Function
- EXP() Function in MySQL
- Char_Length()Function AND ASCII() Function in MariaDB
- SECOND Function and SYSDATE Function in MariaDB
- ASIN(), ACOS() and ATAN() Function in MariaDB
- MID(), POSITION() and LENGTH() Function in MariaDB
- LPAD, LOWER and LTRIM Function in MariaDB
- FLOOR(), GREATEST() and LEAST() Function in MariaDB
- Max(), Min() and Mod() Function in MariaDB
- SIGN (), SQRT () and SUM () Function in MariaDB
- ADDDATE() and ADDTIME() Function in MariaDB
- RADIANS(), RAND() and ROUND() Function in MariaDB
- Sin(), Cos() and Tan() Function in MariaDB
- POWER(), SUM() and PI() Function in MariaDB
- MAKEDATE() and LOCALTIMESTAMP() Function in MariaDB
- LOCALTIME() and LAST_DAY() Function in MariaDB
- DATE() and DATE_ADD() Function in MariaDB
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.