TAN (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![yes](media/yes.png)Azure SQL Data Warehouse ![yes](media/yes.png)Parallel Data Warehouse

Returns the tangent of the input expression.

Topic link icon Transact-SQL Syntax Conventions

Syntax

TAN ( float_expression )  

Arguments

float_expression
Is an expression of type float or of a type that can be implicitly converted to float, interpreted as number of radians.

Return Types

float

Examples

The following example returns the tangent of PI()/2.

SELECT TAN(PI()/2);  

Here is the result set.

----------------------  
1.6331778728383844E+16  

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

The following example returns the tangent of .45.

SELECT TAN(.45);  

Here is the result set.

--------  
0.48

See Also

Mathematical Functions (Transact-SQL)