List:General Discussion« Previous MessageNext Message »
From:Clifton R [CC] Jones Date:April 11 2003 2:57pm
Subject:RE: rounding/truncation of decimal fields
View as plain text  
No, I think he was surprised to find mySQL rounded two identical values
*differently*.. please read his posting for the results....


> -----Original Message-----
> From: gerald_clark [mailto:gerald_clark@stripped]
> Sent: Friday, April 11, 2003 9:33 AM
> To: Matt Loschert
> Cc: mysql@stripped
> Subject: Re: rounding/truncation of decimal fields
> 
> 
> Why do you find this surprising?
> You defined the field to have 2 deciimal places..
> 
> Matt Loschert wrote:
> 
> >I have quick question about rounding and/or truncation of a 
> decimal table
> >field.  I ran into this unexpectedly and found it surprising.
> >
> >Given the following input:
> >
> >
> >  DROP TABLE IF EXISTS test1;
> >  CREATE TABLE test1 (id tinyint, truncated decimal(12,2));
> >  INSERT INTO test1 VALUES (1, '0.004');
> >  INSERT INTO test1 VALUES (2,  0.004 );
> >  INSERT INTO test1 VALUES (3, '0.005');
> >  INSERT INTO test1 VALUES (4,  0.005 );
> >  SELECT * FROM test1;
> >  SELECT VERSION();
> >
> >
> >  
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
Thread
rounding/truncation of decimal fieldsMatt Loschert10 Apr
  • Re: rounding/truncation of decimal fieldsgerald_clark11 Apr
RE: rounding/truncation of decimal fieldsClifton R [CC] Jones11 Apr
  • Re: rounding/truncation of decimal fieldsgerald_clark11 Apr
    • Re: rounding/truncation of decimal fieldsMatt Loschert11 Apr
      • Re: rounding/truncation of decimal fieldsDoug Thompson11 Apr
        • Re: rounding/truncation of decimal fieldsMatt Loschert12 Apr
          • Re: rounding/truncation of decimal fieldsDoug Thompson12 Apr
            • More on enumMartin Gainty12 Apr
            • Re: rounding/truncation of decimal fieldsMatt Loschert13 Apr
              • Re: rounding/truncation of decimal fieldsDoug Thompson13 Apr
              • Re: rounding/truncation of decimal fieldsDan Nelson13 Apr
                • Re: rounding/truncation of decimal fieldsMatt Loschert14 Apr
Re: rounding/truncation of decimal fieldsMoon79611 Apr