Forum OpenACS Development: Response to How can i display "formatted_price" with a comma between every three digits?

Collapse
4: Response to How can i display "formatted_price" with a comma between every three digits? (response to 1)
Posted by Andrew Piskorski on 10/30/01 11:51 AM
Yeah, util_commify_number will do the trick, but if you're getting the number from an Oracle query, you probably want to use Oracle's to_char function. E.g.: 
SQL> select
  to_char(123456, '999,990.00')  as number_pretty
from dual;

NUMBER_PRET
-----------
 123,456.00
I dunno about with Postgres.