select * from Table where createdate between @StartDate and @EndDate
条件自己定义。根据需要。
select * from tb where s_time>='2013-04-06' and e_time<'2013-04-11'
