Oracle rounding question - Oracle Database

kboudreau

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

Subscribe Reply

10175

nobody

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

Ivica Dimjasevic

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

Similar topics

7812

vb.net 2003 rounding decimal value question

by: spebola | last post by:

I am using vb.net 2003 professional and I get the following results when using the round method: dim Amount as decimal = 180.255 Amount = Amount.Round(Amount, 2) Amount now contains 180.25. ...

Visual Basic .NET

13622

Rounding error casting from float to int

by: 6tc1 | last post by:

Hi all, I just discovered a rounding error that occurs in C#. I'm sure this is an old issue, but it is new to me and resulted in a fair amount of time trying to track down the issue. Basically...

C# / C Sharp

2242

Rounding Problem

by: Jason | last post by:

I am having a rounding problem in a value i am trying to display in VB.NET. If I have the following code: Dim x As Single = 2726.795 Dim y As Single = Math.Round(2726.795, 2) Dim s as String =...

Visual Basic .NET

3145

Unwanted rounding

by: Marco | last post by:

Hello, I have : float f = 36.09999999; When I do : char cf; sprintf(cf,"%0.03lf", f); I get : 36.100

C / C++

6143

double to float rounding error in 8th digit

by: Shirsoft | last post by:

I have a 32 bit intel and 64 bit AMD machine. There is a rounding error in the 8th digit. Unfortunately because of the algorithm we use, the errors percolate into higher digits. C++ code is...

C / C++

2146

Really weird rounding

by: alsmeirelles | last post by:

Hi all, I Have run this test: Private Sub test() Dim d As Double Dim f As Single Dim output As String d = 8888888888888.8887

by: md | last post by:

Hi Does any body know, how to round a double value with a specific number of digits after the decimal points? A function like this: RoundMyDouble (double &value, short numberOfPrecisions) ...

C / C++

4955

Rounding a floating point number

by: jacob navia | last post by:

Hi "How can I round a number to x decimal places" ? This question keeps appearing. I would propose the following solution #include <float.h> #include <math.h>

C / C++

204

Oracle rounding question

by: kboudreau | last post by:

rounding question.... I have this: 1 select cltv 2 from empower.mtgterms 3* where lnkey = '304076'

Oracle Database

7124

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6998

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7163

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7200

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7375

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4904

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4586

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3078

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

651

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP