Originally posted by raf ok,
I tried with TO_CHAR but I don't know what format musk I must use
The G's in the format string becomes . or ,
depending on your NLS_LANG. And D become
, og . also depending on your NLS_LANG.
Or put simply: Most likely G will be , and D . if
you are in a country which uses . as a decimal
separation char, or vice versa otherwise.