Last updated 1 year ago
Returns a numeric value, rounded to the specified length or precision. ().
ROUND ( numeric_expression , length [ ,function ] )
ROUND( <input_expr> [, <scale_expr> ] )
Code:
SELECT ROUND(123.9994, 3) AS COL1, ROUND(123.9995, 3) AS COL2;
Result:
COL1 |COL2 | --------+--------+ 123.9990|124.0000|
COL1 | COL2 | --------+------+ 123.999|124.000|