# RADIANS(), RAND() and ROUND() Function in MariaDB

Last Updated : 20 Oct, 2020

In MariaDB, RADIANS() function is used to return a value in degrees converted to radians. In this function, a number (an angle in degrees) will be passed as a parameter.

`180 degrees = Ï€ radians`

Syntax :

`RADIANS(number)`

Returns : A value in radians for the angle input in degrees.

Example-1 :

`SELECT RADIANS(180);`

Output :

`3.141592653589793`

Example-2 :

`SELECT RADIANS(-14.5);`

Output :

`-0.2530727415391778`

Example-3 :

`SELECT RADIANS(30);`

Output :

`0.5235987755982988`

2. Rand() :
In MariaDB, RAND() function is used to return a random number or a random number within a range. In this function, the seed will be passed as a parameter. It is optional, it specifies a repeatable sequence of random numbers each time that seed value is provided. If a seed value is given then this function will return a repeatable sequence of random numbers each time using that seed value.

Syntax :

`RAND([seed])`

Returns : A value between 0 (inclusive) and 1 (exclusive) and if no seed is given then this function will provide a random number.

Example-1 :

`SELECT RAND();`

Output :

`0.3456785735094069`

Example-2 :

`SELECT RAND(8);`

Output :

`0.15668530311126755`

Example-3 :

`SELECT RAND()*(10-1)+1;`

Output :

`1.564445336986748`

3. ROUND() :
In MariaDB, Round() function is used to return a number rounded to a certain number of decimal places. In this function, two parameters will be passed, the first is the number that will be round, and the second will be a number rounded to a certain number of decimal places. The decimal number of places must be positive or negative.

Syntax :

`ROUND(number, [decimal_places])`

Returns : The rounded off value for the decimal input.

Example-1 :

`SELECT ROUND(55.543, 1);`

Output :

`55.5`

Example-2 :

`SELECT ROUND(-89.53);`

Output :

`-89`

Example-3:

`SELECT ROUND(579.984, 0);`

Output :

`579`