Sql里日期差用datediff或者用C#
DateTime dtStart = new DateTime(2004,1,1);
DateTime dtEnd = new DateTime(2004,12,31);
TimeSpan tsDays = dtEnd - dtStart;
Console.WriteLine(tsDays.Days.ToString());
DateTime dtStart = new DateTime(2004,1,1);
DateTime dtEnd = new DateTime(2004,12,31);
TimeSpan tsDays = dtEnd - dtStart;
Console.WriteLine(tsDays.Days.ToString());
if exists (select * from boxtable where insertdate > dateadd(day, -7, getdate()) )
begin
--提示
end
else
begin
--插入操作
end
如果是sql方式解决的话。
可以这样写 sql="select count(*) from table where boxid=@boxid And DateDiff(getdate(),
datetime,"dd")<7"
如果能够得到 则说明有啊 如果是再c#里面实现,就如一楼所言。