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

Question

"select * from cases where date between '"&bdate&"' and '"&edate&"' order by id desc"
这样有错吗
//bdate开始时间
//edate结束时间
select * from cases where [date] > bdate and [date] < edate order by id desc
也不行

Answer 1

select * from caiwu where date<='"&edate&"' and date>='"&bdate&"' order by id desc"

Answer 2

select * from cases where [date]<='"&edate&"' and [date]>='"&bdate&"' order by id desc"