% t=date+1 t1=date+8 set OraDatabase = OraSession.getDatabaseFromPool(10) set OraDynaset = OraDatabase.CreateDynaset("select * from cs_td_tdxx where cs_td_tdxx.jhks >= TIMESTAMP '"&t&" 00:00:00' and cs_td_tdxx.jhks <= TIMESTAMP '"&t1&" 23:59:59' order by cs_td_tdxx.jhks", 0) %>