Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

ACOS (Transact-SQL)

A mathematical function that returns the angle, in radians, whose cosine is the specified float expression; also called arccosine.

Topic link iconTransact-SQL Syntax Conventions


ACOS ( float_expression )

float_expression

Is an expression of the type float or of a type that can be implicitly converted to float, with a value from -1 through 1. Values outside this range return NULL and report a domain error.

The following example returns the ACOS of the specified number.

SET NOCOUNT OFF;
DECLARE @cos float;
SET @cos = -1.0;
SELECT 'The ACOS of the number is: ' + CONVERT(varchar, ACOS(@cos));

Here is the result set.

--------------------------------- 
The ACOS of the number is: 3.14159 

(1 row(s) affected)

Community Additions

ADD
Show:
© 2015 Microsoft