ROUND
Rounds the given input to a given number of decimal places.
Syntax
ROUND(X [, D])
Arguments
X
X
Type: numeric
A numeric value.
D
D
Type: bigint
Default: 0
(Optional) The number of decimal places to keep.
If omitted, the precision defaults to 0 and X
is rounded to the nearest integer.
Returns
Type: same as input X
X
rounded to D
decimal places.
Examples
X
D
Output
1.1
1.0
-1.1
-1.0
1.9
2.0
-1.9
-2.0
1
1
1
5
1
1.23
1
1.2
1 + 1
2
0
0
-1
-1
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,
ROUND(nettotal, 0) AS rounded_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
rounded_nettotal
04xYsBwxOW
550.05
550
cu7qwoPA8q
1871.68
1872
dB91uTY7Vv
1538.02
1538
Last updated