How to add thousand separator to a number?

[Ken]

I see that there’s the TO_CHAR() function can format numbers.

However, I cannot find what formatters I can use to add thousand separator to a number.

E.g. 999999999 → 999,999,999

TO_CHAR | Dremio Documentation

[Ken]

I got the formatter from AI.

While it did not get the function name right, it did give me the correct formatter.

This is working for me :)))