Mathematical Functions
This page lists the mathematical functions that are available in the GSQL query language. They are divided into three categories:
-
General
-
Logarithmic
-
Trigonometric
General
floor()
rand()
Description
Returns a completely random number >= 0 and <1. If seed
is specified, it returns a repeatable sequence of random numbers. If no seed is specified, it returns a completely random number.
round()
Description
Rounds a number to a specified place relative to the decimal point and returns the result.
Parameters
Parameter | Description | Data type |
---|---|---|
|
The number to be rounded |
|
|
Optional. An integer value indicating the place to round the first
argument to. + If |
|
sign()
trunc()
Parameters
Parameter | Description | Data type |
---|---|---|
|
The number to be truncated |
|
|
Optional. The integer indicating the decimal place to truncate the number to. If |
|