By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Oracle rounding question

P: n/a

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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
basic math says round of
81.1549296
says the answer is 81.15
round of 81.155 to 2 decimals would be 81.16
"kboudreau" <me*********@dbforums.com> wrote in message
news:30****************@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

Jul 19 '05 #2

P: n/a
SQL> select round(cltv + 0.01, 2) from empower.mtgterms where lnkey =
'304076'

Ivica

"kboudreau" <me*********@dbforums.com> wrote in message
news:30****************@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


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.