need help with formatting a number [message #399373] |
Tue, 21 April 2009 19:46  |
umajava
Messages: 8 Registered: December 2008
|
Junior Member |
|
|
I am using below code to format a number. I am trying the below query to support following output values
1. 126262.00 converted to 126,262 (This is working fine)
2. 126262.45 converted to 126,262.45 (This is working fine)
3. 126262.6 converted to 126,262.60 (This is not working as expected)
select
trim(rtrim(to_char('126262.6', 'FM9,999,999,999.99'), '.'))
from dual
Can anyone help me please?
|
|
|
|
|
|
|