Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

ATAN

SQL Server 2000

Returns the angle in radians whose tangent is the given float expression (also called arctangent).

Syntax

ATAN ( float_expression )

Arguments

float_expression

Is an expression of the type float.

Return Types

float

Examples

This example takes a float expression and returns the ATAN of the given 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)

See Also

CEILING

Mathematical Functions

Show:
© 2014 Microsoft