Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why do my numbers round/truncate???

Why do my numbers round/truncate???

From: <stuco_at_mailcity.com>
Date: Tue, 19 Jan 1999 15:52:30 GMT
Message-ID: <7829no$3sj$1@nnrp1.dejanews.com>


Oracle 7.3.3
AIX 4.2 Hi all!

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 question... WHY!!!

Thanks for all your help.

Stuart Cowen
Paladin Consulting - Dallas

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 09:52:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US