MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References

MariaDB COS() Function



The MariaDB COS() function returns trigonometric cosine of an angle (angle should be in radians).

Syntax

COS(x)

Parameters

x Required. Specify the angle in radian.

Return Value

Returns the trigonometric cosine of an angle.

Example 1:

The example below shows the usage of COS() function.

SELECT COS(0);
Result: 1

SELECT COS(1);
Result: 0.5403023058681398

SELECT COS(-1);
Result: 0.5403023058681398

SELECT COS(2);
Result: -0.4161468365471424

SELECT COS(-2);
Result: -0.4161468365471424

SELECT COS(PI());
Result: -1

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 1-10
Data 2-5
Data 30
Data 45
Data 510

The statement given below can be used to calculate the trigonometric cosine value of column x.

SELECT *, COS(x) AS COS_Value FROM Sample;

This will produce the result as shown below:

DataxCOS_Value
Data 1-10-0.8390715290764524
Data 2-50.28366218546322625
Data 301
Data 450.28366218546322625
Data 510-0.8390715290764524

❮ MariaDB Functions