Re: TO_NUMBER PROBLEM

"karl" <karl_at_post1.com> wrote:

>When I use tonumber to return with a format mask the decimal points get
>lost.
>Although I use ther format mask. Is this an Oracle bug or there is some way
>round it
>eg to_number('1.200',-999.9999) returns 1.2 when i want 1.200. Can anyonoe
>please HELP.
>Thanks in advance KARL

You didn't say, but I'm assuming you're using SQLPLUS. You can alias the function and set a display format for it to get the desired result

column mynum format 9999.9999
select
  to_number(col,-999.9999) mynum
from
  mytable;

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!