to_number Problem
From: karl <karl_at_post1.com>
Date: 1996/12/01
Message-ID: <01bbdd34$62a77480$LocalHost_at_nikhil.pacific.net.sg>#1/1
Date: 1996/12/01
Message-ID: <01bbdd34$62a77480$LocalHost_at_nikhil.pacific.net.sg>#1/1
Does anybody know of a way for a function to return the number with its
decimal places
INCLUDING zeros ie to the right of the decimal places.
the number was orignal in char(Dont ask why) and we used to number to
conver it with
a format mask ie to_number('1.200',999.999) and we still got 1.2 when we
require 1.200
.Is this a bug with the function to_number or do we have to specifically
set up som,ething inthe ora.ini.
Oracle 7.2.3.
Thanks in advance KARL
Received on Sun Dec 01 1996 - 00:00:00 CET