常用的情况: between: select * from [tablename] where [日期] between '2008-01- 01' and '2008-10-31'
zhidao.baidu.com