GAMMA Function

Returns the value of the gamma function.

Category: Mathematical
Returned data type: DOUBLE

Syntax

GAMMA(expression)

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

Restriction Nonpositive integers are invalid.
Data type DOUBLE
See <sql-expression>
FedSQL Expressions

Details

The GAMMA function returns the integral, which is given by the following equation.
For positive integers, GAMMA(x) is (x − 1)!. This function is commonly denoted by cap gamma , open x close.

Example

The following statement illustrates the GAMMA function:
Statements
Results
select gamma(6);
120
Last updated: February 23, 2017