I need help with TO_CHAR function. Can any one help?
From: G <gennt_at_hotmail.com>
Date: Wed, 07 Feb 2001 11:56:02 GMT
Message-ID: <mJag6.7760$iM6.955632_at_newsread1.prod.itd.earthlink.net>
Date: Wed, 07 Feb 2001 11:56:02 GMT
Message-ID: <mJag6.7760$iM6.955632_at_newsread1.prod.itd.earthlink.net>
Hello all.
[Quoted] Why I am getting four (####), instead of getting only three(###), when run
this statement:
SELECT TO_CHAR(50,'0V00') FROM DUAL;
[Quoted] [Quoted] In my opinion it should show me 3(###) signs or I am wrong. Any one can help
[Quoted] [Quoted] me or lead me why is this happening. I think it's a bug with TO_CHAR
function.
[Quoted] Thanks for your help Received on Wed Feb 07 2001 - 12:56:02 CET