round

Description

Returns ‘val’ rounded to the given ‘precision’. Precision defaults to 0, meaning the value will be rounded to the nearest integer.

Return type

prec

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

round( val [ , precision ] )

Argument

Type

Required

Multiple

Constant

val

numeric

Required

Only one

Variable

precision

int64

Optional

Only one

Constant

Examples

make_col rounded:round(@.temperature, 2)

Return the rounded value of column temperature with 2 decimals