k3vsmith
asked on
Oracle SQL output change number to 99.99 format
I have a field that Im selecting called percentcomplete.
Select PHYSICALPERCENTCOMPLETE
From Tablex
Where currently the output looks like:
87.765342
65.546323773
2
0
100
38.4
I want to change my sql select so that it displays only 2 numbers past the decimal:
87.76
65.54
2.00
0.00
100.00
38.40
How do I change this?
Select PHYSICALPERCENTCOMPLETE
From Tablex
Where currently the output looks like:
87.765342
65.546323773
2
0
100
38.4
I want to change my sql select so that it displays only 2 numbers past the decimal:
87.76
65.54
2.00
0.00
100.00
38.40
How do I change this?
select to_char(PHYSICALPERCENTCOM PLETE,'999 .00') from tablex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This works but anything that was a 0 is now outputting as .00
This isnt a huge problem but anyway to get that to also output as 0.00?
This isnt a huge problem but anyway to get that to also output as 0.00?
ASKER
Ah, thanks!
ASKER
Thanks guys!
From Tablex