select * from captain_arrange where create_date between to_Date(20120723,'yyyymmdd') and to_date(20120805,'yyyymmdd')