答复: 答复: Some questions about the Derby

[王旭]

Hi

        I'm sorry for the statement of SQL script (select 350000.0 /1000* RT 
from CV where age = 20;).
        The SQL script we have used is " select 350000.0 * RT/1000 from CV 
where age = 20;"
        But I do not understand why the two execution results of SQL script are 
inconsistent, and why the above execution results of SQL script appears 
".9999999"?

-----邮件原件-----
发件人: Bryan Pendleton [mailto:bpendleton.de...@gmail.com] 
发送时间: 2012年12月22日 0:07
收件人: Derby Discussion
抄送: 王旭; 'Knut Anders Hatlen'
主题: Re: 答复: Some questions about the Derby

>       In ij, I re-verify these statements and the results the same with you.
>       But I use java code using a JDBC connection Derby ,it will appear.
>       Can you help me explain the problem?

How are you displaying the result?

Are you using java.text.DecimalFormat?

If you are, what is your format pattern?

thanks,

bryan