Rounding of numeric value in postgres

Question

In PostgreSQL I am using the function round but it does not return decimal point. See the example

select round(10.65)

returns 11, but actually I need 11.00.

I also tried

select round(10.65, 2)

and it returns 10.65.

How to return the numeric value with two decimal points in PostgreSQL?

I want the output like this select round(10.65) should return 11.00. How to make it possible?

jason_jiang · Accepted Answer · 2017-01-13 06:02:14Z

3

I think you should do this:

 select round(round(10.65),2);

answered Jan 13, 2017 at 6:02

jason_jiang

462 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1