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

	I'm sorry for the statement of SQL script (select 350000.0 /1000* RT from CV where age =
	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?



View raw message