tan-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
TAN (Transact-SQL)	TAN (Transact-SQL)	MikeRayMSFT	mikeray	03/03/2017	sql	t-sql	reference	TAN_TSQL TAN	TAN function tangent	TSQL	>= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric

TAN (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]

Returns the tangent of the input expression.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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);  

[!INCLUDEssResult]

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

Examples: [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]

The following example returns the tangent of .45.

SELECT TAN(.45);  

[!INCLUDEssResult]

--------  
0.48

See Also

Mathematical Functions (Transact-SQL)