Re: Function TO_CHAR

"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

This accounts for the sign. The negative sign is a '-' the positive sign is a space. If you don't want that use the fm modifier in front of 0999.

Sybrand Bakker
Senior Oracle DBA Received on Thu Nov 04 2004 - 07:57:46 CST