Re: zero filling a number

From: Troy & Michelle Dodsworth <troydods_at_storm.ca>
Date: Sun, 28 Sep 2003 11:32:07 -0400
Message-ID: <bl6uu1$9j1$1@news.storm.ca>

Thanks works great, I thought I had tried this but it was late :-).

"Eric Parker" <eric.parkerthedross_at_virgin.net> wrote in message news:xCwdb.1564$QH3.21_at_newsfep4-winn.server.ntli.net...
> "Troy & Michelle Dodsworth" <troydods_at_storm.ca> wrote in message
> news:bl5epj$pc4$1_at_news.storm.ca...
> > Why does select to_number(' 123',000999) from dual
> >
> > return 123 rather than the expected 000123 ? since the is the suppose
to
be
> > the purpose of the pattern ?
> >
> > Troy.
> >
> >
>
> Troy
>
> Shouldn't your SQL be :
>
> select to_char(123,'000999') from dual
>
> eric
>
> --
> Remove the dross to contact me directly
>
>
Received on Sun Sep 28 2003 - 10:32:07 CDT