ATAN (Transact-SQL)

ATAN (Transact-SQL)

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

Other versions are also available for the following:

SQL Server 2005

ATAN (Transact-SQL)

Returns the angle in radians whose tangent is a specified float expression. This is also called arctangent.

Topic link icon Transact-SQL Syntax Conventions

Syntax

ATAN (float_expression )

Arguments

float_expression: Is an expression of the type float or of a type that can be implicitly converted to float.

Return Types

float

Examples

The following example takes a float expression and returns the ATAN of the specified angle.

SELECT 'The ATAN of -45.01 is: ' + CONVERT(varchar, ATAN(-45.01))
SELECT 'The ATAN of -181.01 is: ' + CONVERT(varchar, ATAN(-181.01))
SELECT 'The ATAN of 0 is: ' + CONVERT(varchar, ATAN(0))
SELECT 'The ATAN of 0.1472738 is: ' + CONVERT(varchar, ATAN(0.1472738))
SELECT 'The ATAN of 197.1099392 is: ' + CONVERT(varchar, ATAN(197.1099392))
GO

Here is the result set.

                                                         
------------------------------- 
The ATAN of -45.01 is: -1.54858                       

(1 row(s) affected)

-------------------------------- 
The ATAN of -181.01 is: -1.56527                       

(1 row(s) affected)

-------------------------------- 
The ATAN of 0 is: 0                              

(1 row(s) affected)

---------------------------------- 
The ATAN of 0.1472738 is: 0.146223                       

(1 row(s) affected)

                                                         
----------------------------------- 
The ATAN of 197.1099392 is: 1.56572                        

(1 row(s) affected)

Reference

CEILING (Transact-SQL)

Mathematical Functions (Transact-SQL)