How to forbid to_char(0,'9G999G999D00') to return .00 ?
Hi,
I never understood why the TO_CHAR function with a mask like '9G999G999G999D00' return something that isn't a proper formated number. Whatever language you are using, separator + 00 isn't a valid number.
How can we prevent that thing ? Shouldn't it fix by Oracle ?
It makes me headaches to write codes to correct that. Even by using the default value it creates me problems.
0 = 0.00 not .00
When it's null, then it's taking 0.00. But we do have some 0 values in our database and they aren't null.
thank you
leinadjan
Edited by: leinadjan on Feb 10, 2011 2:36 PM
Edited by: leinadjan on Feb 10, 2011 2:37 PM