FLOOR
Rounds the given input down to the nearest integer.
Syntax
FLOOR(X)
Arguments
X
X
Type: numeric
A numeric value.
Returns
Type: same as input
X
rounded down to the nearest integer.
Examples
X
Output
0.13523523
0.0
-0.1
-1.0
-1.1
-2.0
1
1
1 + 1
2
0
0
-1
-1
-1 - 5
-6
Transformation job example
SQL
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data
MAP_COLUMNS_BY_NAME
SELECT
orderid,
nettotal,
FLOOR(nettotal) AS floor_nettotal
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 3;
Query result
orderid
nettotal
floor_nettotal
04xYsBwxOW
550.05
550
cu7qwoPA8q
1871.68
1871
dB91uTY7Vv
1538.02
1538
Last updated