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

TAN ( float_expression )  

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

float

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

SELECT TAN(PI()/2);  

Here's the result set.

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

The following example returns the tangent of .45.

SELECT TAN(.45);  

Here's the result set.

--------  
0.48

Mathematical Functions (Transact-SQL)