select * from MONITOR_BASE where "TO_DATE"(ACCEPTTIME,'yyyy-mm-dd hh24:mi:ss') between "TO_DATE"('2012-08-01','yyyy-mm-dd hh24:mi:ss') and "TO_DATE"('2012-09-01','yyyy-mm-dd hh24:mi:ss')
select * from MONITOR_BASE where "TO_DATE"(ACCEPTTIME,'yyyy-mm-dd hh24:mi:ss') between "TO_DATE"('2012-08-01','yyyy-mm-dd hh24:mi:ss') and "TO_DATE"('2012-09-01','yyyy-mm-dd hh24:mi:ss')