ATN2() Function in SQL Server

Last Updated : 29 Sep, 2020

In this article, we are going to cover the ATN2()function in which we will see how we can get the arc tangent of two given numbers. Let's discuss one by one.

  // here val1 and val2 are input.  Input  : ATN2(val1, val2)       Output : Arc tangent result.

ATN2() : It is the function that returns the arc tangent of two numbers. Syntax :

  ATN2(val1, val2)

Parameter : This method accepts two-parameters as mentioned above and described below.

val1, val2: It is the two numeric values to calculate the arc tangent.

Returns - It returns the arc tangent of two numbers. Example-1 : When the arguments hold the positive number.

  SELECT ATN2(2.53, 5.6);

Output :

  0.42433793483800258

Example-2 : When the arguments hold the negative number.

  SELECT ATN2(-2.53, -5.6);

Output :

  -2.7172547187517906

Example-3 : When the PI() function passing one of the arguments.

  SELECT ATN2(PI(), 4);

Output :

  0.66577375002835382

DATEADD() Function in SQL Server

sanjoy_62

Improve

Article Tags :

Similar Reads

DAY() Function in SQL Server

DAY() function : This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated. Features : This function is used to find the day of the month for a date specified. This function comes under Date Functions. This function accepts only one parameter i.e, date.

2 min read

AVG() Function in SQL Server

The AVG() function in SQL Server is an essential aggregate function used to compute the average value of a numeric column. It works by summing all non-NULL values in the specified column and then dividing the total by the number of these values. In this article, We will learn about AVG() Function in

4 min read

DATENAME() Function in SQL Server

DATENAME() function : This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as a string. Features : This function is used to find a given part of the specified date.This function comes under Date Functions.This function accepts two para

2 min read

DATEADD() Function in SQL Server

DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns the modified date. Features : This function is used to sum up a time or a date interval to a date specified. This function comes under Date Functions. This function accepts

3 min read

COUNT() Function in SQL Server

The COUNT() function in SQL Server is a fundamental aggregate function used to determine the number of rows that match a specific condition. Counting rows provides valuable insights into data sets such as the total number of records, distinct values, or records meeting certain criteria. In this arti

3 min read

DATALENGTH() Function in SQL Server

DATALENGTH() : This function returns the length of an expression and expression length will be in bytes. Syntax : DATALENGTH( expression ) Parameter - This method accepts a single-parameter as mentioned above and described below as follows. Expression - It is an expression of the data type to return

1 min read

ASCII() Function in SQL Server

The ASCII() function returns the ASCII value of the leftmost character of a character expression. Syntax : ASCII(character_expression) Parameter : This method accepts a single-parameter as mentioned above and described below : character_expression : It can be a literal character, an expression of a

2 min read

DATEPART() Function in SQL Server

DATEPART() function :This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as an integer.Features : This function is used to find a given part of the specified date.This function comes under Date Functions.This function accepts two para

2 min read

SQL Server LEN() Function

SQL SERVER LEN() function calculates the number of characters of an input string, excluding the trailing spaces. LEN() Function in SQL ServerThe LEN function in the SQL Server fetches the number of characters in a string. It counts the preceding spaces but not the trailing spaces. For eg, 'SQL SERVE

2 min read

SQL Server ABS() Function

The SQL Server ABS() function is a mathematical function used to return the absolute value of the given numeric expression. This function effectively removes any negative sign from input ensuring that the result is always non-negative. It is commonly used in data analysis and calculations where only

4 min read