CEIL¶
The CEIL function returns the smallest integer that is larger than or equal to the supplied number. The result is cast into a integer type in the operation.
Usage¶
CEIL(number) : integer
Example¶
The example query adds a calculated column with a value of 5, which is the smallest integer that is larger than the supplied number.
gorrow chr1,1,1 | CALC test ceil(4.2)
chrom bpStart bpStop test
chr1 1 1 5