SQLite Tutorial SQLite Advanced SQLite Database SQLite References
SQLite Tutorial SQLite Advanced SQLite Database SQLite References

SQLite COS() Function

The SQLite 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.0

SELECT COS(1);
Result: 0.54030230586814

SELECT COS(-1);
Result: 0.54030230586814

SELECT COS(2);
Result: -0.416146836547142

SELECT COS(-2);
Result: -0.416146836547142

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

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.839071529076452
Data 2-50.283662185463226
Data 301.0
Data 450.283662185463226
Data 510-0.839071529076452

❮ SQLite Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.