TAN (Transact-SQL)

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

Returns the tangent of the input expression.

👁 Image
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's the result set.

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

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

The following example returns the tangent of .45.

SELECT TAN(.45); 

Here's the result set.

-------- 
0.48

See Also

Mathematical Functions (Transact-SQL)