On Tue, Mar 9, 2021 at 1:28 PM Vincent Veyron <vv.li...@wanadoo.fr> wrote:
> For the record below, I wish to display 'credit' properly formated in an > html form, using to_char(credit, 'FM999G990D00') > > ^^^^^^^^^^^^^ ^^^^^^^^^^^^ > What can I do to get a standard space as group separator for my numbers? > By using "G" you are giving up control and letting your locale settings decide what gets output. You can continue to use to_char but take control back by being explicit, or pass actual numbers into and out of the database and let your front-end deal with presentation concerns. I suggest the latter. David J.
