string sql = "select * from [FEvaluation] where CourseName='" + courseName + "' and FEDate between DataTime.Now.AddDays(-20) and DateTime.Now.Date.ToString(yyyy-mm-dd)";
知道不大对,但是不知道怎么改(我也么啥分,各位就当行好吧^_^)
知道不大对,但是不知道怎么改(我也么啥分,各位就当行好吧^_^)
string sql = "select * from [FEvaluation] where CourseName=N'" + courseName + "' and FEDate between "+ DataTime.Now.AddDays(-20)
+ " and + " DateTime.Now.Date.ToString(yyyy-mm-dd)";
凑合着用吧(看起来怎么就这么别扭呢 ~.~)
string sql = "select * from [FEvaluation] where CourseName='" + courseName + "' and convert(varchar(10),FEDate,120) between '"+ DateTime.Now.AddDays(-20).ToString("yyyy-MM-dd")+"' and '"+ DateTime.Now.Date.ToString("yyyy-MM-dd")+"'";
string sql = "select * from [FEvaluation] where CourseName=N'" + courseName + "' and FEDate between '"+ DataTime.Now.AddDays(-20)
+ "' and '" + DateTime.Now.Date.ToString(yyyy-mm-dd) + "' "; 有点晕。。
或
时间 between '2008-01-01 00:00:00.000' and '2008-01-05 23:59:59.997'ToString("")用"",MM大写,都是错误