Skip to content
Advertisement

number formatting 9’999.00

I’d like to format a number in a SQL select like this

How can I do this?

It works for 9,999,999 with the following command

Advertisement

Answer

You are almost there. Just replace group separator (.) with a single quote (') and you are good to go.

result:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement