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

Günther De Vogelaere · *nix forums beginner Joined: 09 Jan 2006 Posts: 2

Hi,

When I execute 'select '*' || to_char(33,'0009') || '*' from dual
I get '* 0033*' instead of '*0033*'.

Does anybody know what might be wrong? Something wrong in my configuration?

sybrandb@yahoo.com · *nix forums Guru Joined: 30 May 2005 Posts: 482

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

Günther De Vogelaere · *nix forums beginner Joined: 09 Jan 2006 Posts: 2

<sybrandb@yahoo.com> schreef in bericht
news:1136814278.434529.146080@g14g2000cwa.googlegroups.com...

Google