Re: to_char (33, '0009') adds an extra white space

From: Günther De Vogelaere <Gunther.DeVogelaere_at_NOSP@M.Ugent.be>
Date: Mon, 9 Jan 2006 15:17:17 +0100
Message-ID: <dptou2$a0c$1@gaudi2.UGent.be>

<sybrandb_at_yahoo.com> schreef in bericht 
news:1136814278.434529.146080_at_g14g2000cwa.googlegroups.com...

> Nothing wrong. Oracle adds automatically a '-' for negative numbers and
> a ' ' for positive numbers.
> (As documented).
> If you don't want that prefix the format with 'fm', so
> to_char(33,'fm0009')
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>

Thx :)

Most examples on the web don't even mention the 'fm'. The strangest thing is, my code (PL/SQL) previously worked flawless without the 'fm' :s Received on Mon Jan 09 2006 - 08:17:17 CST