You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by 王旭 <wa...@sinosoft.com.cn> on 2012/12/24 04:32:55 UTC

答复: 答复: 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.derby@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