blob: ca9a7edbeaed428a41450e47fe93df4ecb513289 [file] [log] [blame]
 Numeric Functions | Ignite Documentation
Edit

Numeric Functions

ABS

ABS (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Returns the absolute value of an expression.

Example

Calculate an absolute value:

SELECT transfer_id, ABS (price) from Transfers;

ACOS

ACOS (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the arc cosine. This method returns a double.

Example

Get arc cos value:

SELECT acos(angle) FROM Triangles;

ASIN

ASIN (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the arc sine. This method returns a double.

Example

Calculate an arc sine:

SELECT asin(angle) FROM Triangles;

ATAN

ATAN (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the arc tangent. This method returns a double.

Example

Get an arc tangent:

SELECT atan(angle) FROM Triangles;

COS

COS (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the trigonometric cosine. This method returns a double.

Example

Get a cosine:

SELECT COS(angle) FROM Triangles;

COSH

COSH (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the hyperbolic cosine. This method returns a double.

Example

Get an hyperbolic cosine:

SELECT HCOS(angle) FROM Triangles;

COT

COT (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the trigonometric cotangent (1/TAN(ANGLE)). This method returns a double.

Example

Gets a​ trigonometric cotangent:

SELECT COT(angle) FROM Triangles;

SIN

SIN (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the trigonometric sine. This method returns a double.

Example

Get a trigonometric sine:

SELECT SIN(angle) FROM Triangles;

SINH

SINH (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the hyperbolic sine. This method returns a double.

Example

Get a hyperbolic sine:

SELECT SINH(angle) FROM Triangles;

TAN

TAN (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Calculates the trigonometric tangent. This method returns a double.

Example

Get a trigonometric tangent:

SELECT TAN(angle) FROM Triangles;

TANH