（oracle,查询指定时间范围的数据，数据double格式化）

 select to_char(navdate,'yyyy-MM-dd') navdate,to_char(netvalue,'FM999999990d9990') netvalue,

 to_char(totalvalue,'FM999999990d9990')totalvalue, trim(to_char(round(DAYRATE*100,2),99990.99)) dayrate from tb_fundzzl_info where fundcode = '000913'to_char(navdate,'yyyy-MM-dd') >'2008-08-08' to_char(navdate,'yyyy-MM-dd') <= '2011-01-01' order by navdate desc