请问这句sql有何错？请大家帮忙看看，谢了.

Question

改成：string selectStr="Select * from order1 where ordertime between '"+convert(datetime,cdate(btime))+"' and '"+convert(datetime,cdate(etime))+"'";

Answer 1

改成：string selectStr="Select * from order1 where ordertime between '"+Convert.ToDateTime(btime)+"' and '"+Convert.ToDateTime(etime)+"'";

Answer 2

其实没那么麻烦，直接
string selectStr="Select * from order1 where ordertime between '2004-01-08' and '2004-11-08';就可以