在Oracle中查询Date类型字段的数据
select * from [表名] where to_char([需要查询的字段],'yyyyMMdd') between '20130601' and '20130630'
select * from [表名] where [需要查询的字段] between to_date('20130601', 'yyyy-mm-dd hh24:mi') and to_date('20130630', 'yyyy-mm-dd hh24:mi')
在Oracle中查询Date类型字段的数据
select * from [表名] where to_char([需要查询的字段],'yyyyMMdd') between '20130601' and '20130630'
select * from [表名] where [需要查询的字段] between to_date('20130601', 'yyyy-mm-dd hh24:mi') and to_date('20130630', 'yyyy-mm-dd hh24:mi')