Re: Why do my numbers round/truncate???

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 26 Jan 1999 12:00:35 +0200
Message-ID: <78k3rn$meb$1@hermes.is.co.za>

stuco_at_mailcity.com wrote in message <7829no$3sj$1_at_nnrp1.dejanews.com>...
>
>I am selecting from the sum of a number(13,2) column that I know has
data
>after the decimal point. But, MY Query is rounding very sporadically.
>Sometimes it rounds, sometimes it doesn't.

My guess is that the problem lies with the client software you're using. Oracle gives it the right data, but the application is the doing "something" to it - maybe not using the correct operating system data types to represent it. Or maybe it's doing a simple formatting error.

regards,
Billy Received on Tue Jan 26 1999 - 04:00:35 CST