Round but keep the 0
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