to_char(123, '999999') problem

From: Marcos Leija <marcos.leija_at_cas-mddc.com>
Date: 2000/05/01
Message-ID: <390E051A.6CF86E98_at_cas-mddc.com>#1/1


[Quoted] [Quoted] How do I get rid of the leading space that to_char() creates when I set it up like this:
to_char(123, '999999')
returns ' 123'

In actuality, I need to_char() to do this: to_char(123, '099999')
...but it does the same thing.

Is this a bug or is this some setting I left out? Marcos Received on Mon May 01 2000 - 00:00:00 CEST

Original text of this message