COS() of any input in radian using MySQL query

SELECT COS(PI()); // Output is -1
SELECT ROUND(COS(PI()/2),2); // Output is 0.00
SELECT ROUND(COS(PI()/3),2); // Output is 0.5

We used ROUND() to show only two decimal places.

Syntax

SELECT COS( X )

X is in Radian

COS() with PI()

mathematical constant PI() (π) value is 3.141593

COS() with RADIANS

Radians function convert degree value to radian.

SELECT COS(RADIANS(0)); // Output is 1
SELECT ROUND(COS(RADIANS(90)),2); // Output is 0.00
SELECT COS(RADIANS(180)); // Output is -1

SQL Math References TAN() to get tangent sin()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

COS() : function to get COS value of any raidan input

COS() with PI()

COS() with RADIANS

Subhendu Mohapatra