CEILING
Rounds the given input up to the nearest integer.
Syntax
Arguments
X
X
Type: numeric
A numeric value.
Returns
Type: same as input
X
rounded up to the nearest integer.
Examples
X | Output |
---|---|
0.13523523 | 1.0 |
-1.1 | -1.0 |
1 | 1 |
1 + 1 | 2 |
0 | 0 |
-1 | -1 |
-1 - 5 | -6 |
Transformation job example
SQL
Query result
orderid | nettotal | ceil_nettotal |
---|---|---|
04xYsBwxOW | 550.05 | 551 |
cu7qwoPA8q | 1871.68 | 1872 |
dB91uTY7Vv | 1538.02 | 1539 |
Last updated