TO_NUMBER PROBLEM
From: karl <karl_at_post1.com>
Date: 1996/12/01
Message-ID: <01bbdf71$25e6c5c0$870574cb_at_nikhil.pacific.net.sg>#1/1
Date: 1996/12/01
Message-ID: <01bbdf71$25e6c5c0$870574cb_at_nikhil.pacific.net.sg>#1/1
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
Received on Sun Dec 01 1996 - 00:00:00 CET