110,561
社区成员
发帖
与我相关
我的任务
分享
using (SqlConnection con = new SqlConnection(""))
{
using (SqlCommand cmd = new SqlCommand())
{
int i = 10;
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from tablename where updatetime between @begin and @end order by updatetime";
cmd.Parameters.Add(new SqlParameter("@begin", DateTime.Now.AddMinutes(-i)));
cmd.Parameters.Add(new SqlParameter("@end", DateTime.Now));
using (SqlDataReader sr = cmd.ExecuteReader())
{
while (sr.Read())
{
//...
}
}
}
}
select * from tablename where updatetime between DATEADD(MINUTE, -10, GETDATE()) and GETDATE() order by updatetime
DateTime nowDate = DateTime.Now;
string startDate = nowDate.AddMinutes(-10).ToString("yyyy-MM-dd HH:mm:ss");
string endDate = nowDate.ToString("yyyy-MM-dd HH:mm:ss");