to_char-function on number causes loss of leading zero
846624Mar 30 2011 — edited Mar 31 2011Hello everybody,
I need to ask a question about the to_char method. I have number-values, which occur in the format " xxxxx,x ", which means:
- a not limited amount of leading digits
- optional a decimal point
- if a decimal point, then the numer has at most one digit afterwards
It looks okay with every kind of number, just the 0,x looks strange.
It is converted to " ,x ", e.g. 0,5 to ,5.
How do I get a proper format?
I used to_char(mynumber, 'FM90D9'), but it has always a decimal point and doesn't work for large numbers.
Thanks in advance!