TAN (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

Returns the tangent of the input expression.

Transact-SQL syntax conventions

Syntax

syntaxsql

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.

SQL

SELECT TAN(PI()/2);  

Here's the result set.

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

Examples: Azure Synapse Analytics and Analytics Platform System (PDW)

The following example returns the tangent of .45.

SQL

SELECT TAN(.45);  

Here's the result set.

--------  
0.48

See Also

Mathematical Functions (Transact-SQL)