ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ACOS function [Numeric]

Function 

• Returns the arc-cosine, in radians, of a numeric expression.

Syntax 

ACOS ( numeric-expression )

Parameters 

numeric-expression    The cosine of the angle.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

ASIN function [Numeric]

ATAN function [Numeric]

ATN2 function [Numeric]

COS function [Numeric]

Example 

The following statement returns the value 1998-06-12.

SELECT YMD( 1998, 06, 12 )

If the values are outside their normal range, the date will adjust accordingly. For example, the following statement returns the value 2000-03-01.

SELECT YMD( 1999, 15, 1 )

Example 

The following statement returns the value 1.023945.

SELECT ACOS( 0.52 )