Oracle rounding question
From: kboudreau <member33017_at_dbforums.com>
Date: Thu, 10 Jul 2003 22:05:28 +0000
Message-ID: <3097653.1057874728_at_dbforums.com>
Date: Thu, 10 Jul 2003 22:05:28 +0000
Message-ID: <3097653.1057874728_at_dbforums.com>
rounding question....
I have this:
1 select cltv
2 from empower.mtgterms
3* where lnkey = '304076'
SQL> /
CLTV
81.1549296
SQL> select round(cltv,2)
2 from empower.mtgterms
3 where lnkey = '304076'
4 /
ROUND(CLTV,2)
81.15
I need it to round the entire number 81.1549296 to 2 decimal places
which would bring 81.16 (6 rounds the 9 to 0 rounds the 2 to 3 rounds
the 9 to 9 rounds the 4 to 5 rounds the 5 to 6 giving 81.16). I can't
use round(round(cltv,3),2) as I don't know in advance how far
out the decimal precision will be. Is there some oracle function that
can help with this?
--
Posted via http://dbforums.com
Received on Fri Jul 11 2003 - 00:05:28 CEST