SQL查询两个时间之间的记录

"select * from cases where date between 'bdate' and 'edate' order by id desc"//bdate开始时间//edate结束时间

 select * from [SuperMarketdb].[dbo].[销售明细表] where [billdate]  between ' 2011-03-13 ' and ' 2011-04-16 ' order by billcode  desc

"select * from cases where [date] between '"&bdate&"' and '"&edate&"' order by id desc"
没有错。
就是要注意你的表中的数据格式，要与bdate edate一致，还有就是不能有空值,否则出错。