Re: Function TO

From: GQ <dbaguy_ott_at_yahoo.com>
Date: 4 Nov 2004 06:39:35 -0800
Message-ID: <aad8b5cb.0411040639.c7a68ca@posting.google.com>

"Petr Benes" <benes_at_epos.cd.cz> wrote in message news:<4189e1f4.0_at_10.140.56.22>...
> Hi
>
> Expression TO_CHAR(15) returns '15'. It is correct.
> Expression TO_CHAR(15,'0999') returns ' 0015' instead '0015'.
> Tested in version 10q as well as 7.3.4.
>
> Do you know why there is the blankspace?
>
> Thanks

It is holding the position for the sign (+/-), and leaves it blank because it is positive number. Received on Thu Nov 04 2004 - 08:39:35 CST

Re: Function TO_CHAR