62,047
社区成员
发帖
与我相关
我的任务
分享
string date0 = "2010-5-24";
string date1 = "2010-5-26";
sql = string.Format("select * from t where d between '{0}' and '{1} 23:59:59'", date0, date1);
string date0 = "2010-5-24";
string date1 = "2010-5-26";
cmd.CommandText = "select * from t where d between @date0 and @date1";
cmd.Parameters.Add("@date0", SqlDbType.SmallDateTime).Value = DateTime.Parse(date0);
cmd.Parameters.Add("@date1", SqlDbType.SmallDateTime).Value = DateTime.Parse(date1).AddDays(1).AddSeconds(-1);
string date0 = "2010-5-24";
string date1 = "2010-5-26";
cmd.CommandText = "select * from t where d between @date0 and @date1"; cmd.Parameters.Add("@date0", SqlDbType.SmallDateTime).Value = DateTime.Parse(date0);
cmd.Parameters.Add("@date1", SqlDbType.SmallDateTime).Value = DateTime.Parse(date1).AddDays(1).AddSeconds(-1);
select * from t where d between '2010-5-25' and '2010-5-26 23:59:59'
cmd.CommandText = "select * from t where d between @date0 and @date1";
cmd.Parameters.Add("@date0", SqlDbType.SmallDateTime).Value = new DateTime(2010,5,24);
cmd.Parameters.Add("@date1", SqlDbType.SmallDateTime).Value = new DateTime(2010,5,26,23,59,59);
SELECT * FROM TABLE WHERE DATEDIFF(d,datetime,'2010-5-26')>=0 AND DATEDIFF(d,'2010-5-24',datetime)>=0