This discussion is archived
2 Replies Latest reply: Nov 30, 2012 4:36 AM by nazzu RSS

Need Help on currency number format

nazzu Newbie
Currently Being Moderated
Hi,

I need to display the amount as with Ruppes and Piase as follows.
If my amount is 1000.00 then i need to display as '1000.00' and if 3456798.54 then i need to display as 3456798.54
i have the sql query as
select to_char('234567.00','FM999G999D99') from dual;
but it is not displaying me the values after '.'
Please help me how to fix this .


Thanks,
Nazzu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points