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

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" <member33017@dbforums.com> wrote in message
news:3097653.1057874728@dbforums.com...[color=blue]
>
> 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[/color]

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

Ivica



"kboudreau" <member33017@dbforums.com> wrote in message
news:3097653.1057874728@dbforums.com...[color=blue]
>
> 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[/color]