asp中查询某字段间的记录
SQL语句查询某时间段内的记录我用的sql语句是这样的
jhtime1的值为2006-10-10
jhtime2的值为2006-10-17
selse * from 表名 where 时间字段>="&jhtime1&" and 时间字段<="&jhtime2&" order by id desc
selse * from 表名 where 时间字段 between "&jhtime1&" and "&jhtime2&" order by id desc
明明表中有记录结果就是找不到．提示没有记录．
请大侠指点．．
