RE: Odd rounding errors with 4.1

2005-02-23 Thread Gordon
[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

Re: Odd rounding errors with 4.1 [Duh, me!]

2005-02-21 Thread Martin
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

Re: Odd rounding errors with 4.1

2005-02-21 Thread Dan Nelson
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

Re: Odd rounding errors with 4.1

2005-02-21 Thread Martin
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:

Re: Odd Rounding?

2004-01-24 Thread Alec . Cawley
"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

RE: Odd Rounding?

2004-01-23 Thread Matt Lynch
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

Re: Odd Rounding?

2004-01-23 Thread Keith C. Ivey
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

Re: Odd Rounding?

2004-01-23 Thread Mikhail Entaltsev
== 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

RE: Odd Rounding?

2004-01-23 Thread Andrew Kuebler
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

RE: Odd Rounding?

2004-01-23 Thread David Brodbeck
> -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