[mailto:[EMAIL PROTECTED]
Sent: Monday, February 21, 2005 7:49 PM
To: Hassan Schroeder; mysql@lists.mysql.com
Subject: Re: Odd rounding errors with 4.1
Huh, you know. Now that I'm not at work and therefore don't have my
numbers to check against, you're right.
Man, I must need more co
Yeah, I checked the math after another responder. Either I was smoking
crack at work today (a state likely induced by too much/too little
caffeine) or I mis-noted my numbers.
I'm going to check again when I get back there tomorrow.
But thanks :)
Martin
Dan Nelson wrote:
In the last episode (Feb
In the last episode (Feb 21), Martin said:
> Version: Using 4.1.10 on WinXP pro, currently interacting with it
> using the Query Browser for testing.
>
> I have a table set up that contains a column of DECIMAL(15,12) --
> financial data, where the precision is highly important. I am
> building up
Huh, you know. Now that I'm not at work and therefore don't have my
numbers to check against, you're right.
Man, I must need more coffee.
Never mind me. :)
May be back tomorrow, though, when I have the numbers in front of me. I
know they didn't add up earlier...
Martin
Hassan Schroeder wrote:
"Andrew Kuebler" <[EMAIL PROTECTED]> wrote on 23/01/2004 17:13:13:
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it to round up?
> I've tried manipulating ceil, floor, round and truncate and I can't seam
> to
Hi Andrew
Consider using NUMERIC or DECIMAL to maintain precision.
>From the manual:
The NUMERIC and DECIMAL types are implemented as the same type by MySQL,
as permitted by the SQL-92 standard. They are used for values for which
it is important to preserve exact precision, for example with mon
On 23 Jan 2004 at 12:13, Andrew Kuebler wrote:
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it to round
> up? I've tried manipulating ceil, floor, round and truncate and I
> can't seam to find an easy way to do th
==
Mikhail.
- Original Message -
From: "Andrew Kuebler" <[EMAIL PROTECTED]>
To: "'David Brodbeck'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 6:33 PM
Subject: RE: Odd Rounding?
> Actually, no, it round
Actually, no, it rounds to .01233.
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it
> to round up?
Oftentimes standard practice is to
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it
> to round up?
Oftentimes standard practice is to round up if the digit before the
10 matches
Mail list logo