[SQL]數值處理

ROUND(n, [m]) --四捨五入(m代表取到第幾位)

SELECT ROUND(5/3, 2) FROM DUAL;
=>1.67


SELECT ROUND(5/3, 0) FROM DUAL;
=>2



TRUNC(n, [m]) --無條件捨去(m代表取到第幾位)

SELECT TRUNC(5/3, 2) FROM DUAL;
=>1.66


SELECT TRUNC(5/3, 0) FROM DUAL;
=>1

[JAVA]POI Example

http://poi.apache.org/spreadsheet/quick-guide.html

http://www.blogjava.net/ltc603/archive/2006/08/16/63804.html

http://hypgr.iteye.com/blog/439820