Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Round but keep the 0

s_dot1985Jun 5 2013 — edited Jun 5 2013
Hi,

I want to round numbers to 2 decimal places but not trim off the trailing 0's.

e.g.

select round (45.601, 2) from dual returns 45.6, but i want 45.60

select round (51, 2) from dual returns 51 but i want 51.00


Is there an easy why to do this?

Thanks!

I'm 11g2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2013
Added on Jun 5 2013
3 comments
9,231 views