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