• 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.

Syntax :

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

Example-1 :

Output :

3.141592653589793

Example-2 :

Output :

-0.2530727415391778

Example-3 :

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
My Personal Notes arrow_drop_up