Example for converting numeric result of function to string with commas

Question

I try to make TOTAL_MONEY to this format "123,456,789" (with commas).

select entity_id,
       'the sum is:' || to_char(TOTAL_MONEY, ',') as text_msg
from(
select entity_id,
       sum(volume) as TOTAL_MONEY
from procurement) t

but it doesn't work. I don't find here something useful.

Can you help me with that?

Abelisto · Accepted Answer · 2017-06-17 10:14:48Z

1

Yet another, simpler solution:

select
  entity_id,
  to_char(TOTAL_MONEY, '"the sum is: "FM999,999,999,999') as text_msg
from(
  select entity_id, sum(volume) as TOTAL_MONEY
  from procurement) t

There are: 'FM' option to remove unnecessary spaces; "double-quoted string" to print it as-is without replacements of any patterns/placeholders.

edited Jun 17, 2017 at 10:14

answered Jun 17, 2017 at 9:53

Abelisto

15.8k3 gold badges38 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anuraag Veerapaneni · Accepted Answer · 2017-06-15 19:53:32Z

1

    select entity_id,
    'the sum is:' || ltrim(rtrim(to_char(TOTAL_MONEY, '999,999,999,999'))) as text_msg
    from(
          select entity_id,
          sum(volume) as TOTAL_MONEY
          from procurement
        ) t

answered Jun 15, 2017 at 19:53

Anuraag Veerapaneni

6795 silver badges17 bronze badges

Collectives™ on Stack Overflow

Example for converting numeric result of function to string with commas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related