ASIN() function

SELECT ASIN( X )

The output is arc sine of X or the value for which SIN() is X

This function takes input in range of -1 to 1, for any other input the output will be NULL.

Let us strat with some known output of Sin.

SELECT ASIN(0);// Output 0
SELECT ASIN(1); // Output is 1.5707963267948966
SELECT ASIN(-2); // Output is NULL

We are getting outputs in radian, so to change the value to degree we will use DEGREES()

ASIN() with DEGREES()

SELECT DEGREES(ASIN(1)); // Ouput is 90
SELECT DEGREES(ASIN(0)); // Output is 0 
SELECT DEGREES(ASIN(-1)); // Output is -90

This article is written by plus2net.com team.

plus2net.com

▼ More on Math functions in SQL

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns

✖

We use cookies to improve your browsing experience. . Learn more

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us