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.
table with 1 row and 1 column , row1 column 1 , g eh m m eh . open x close , equals , integral , from , 0 , to , infinity , of . t super x minus 1 end super . e super negative t end super , d t . , end table
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