db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 王旭 <wang...@sinosoft.com.cn>
Subject 答复: 答复: Some questions about the Derby
Date Mon, 24 Dec 2012 03:32:55 GMT
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


Mime
View raw message