Oracle query by time period
Select * from [Tablename] where [create_time]> = to_date ('2004-07-01', 'YYYY-mm-dd') and [create_time] <= to_date ('2004-08-01', 'YYYY-MM -Dd ')
Pass at the 9i version. Attention time format (including bit) alignment.