查询某段时间内的记录 select * from table t where (TO_CHAR(t.create_date,'YYYYMMDD') BETWEEN '20110301' AND '20110331')