asp获取数据表问题：需要获取不是今天与昨天更新的数据表数量
ifIsSqlDataBase=0thensql="SELECTcount(id)ascountidFROMcountwhereDateDiff('d',time1,no...
if IsSqlDataBase = 0 then
sql = "SELECT count(id) as countid FROM count where DateDiff('d', time1,now())=0"
else
sql = "SELECT count(id) as countid FROM count where DateDiff(d, time1,getdate())=0"
end if
rs2.Open sql,conn,1,1
if not rs2.eof then
todaycount=rs2("countid")
end if
rs2.close
这是代表今天更新的数据表数量， 目前想获取不是今天与昨天更新的数据表数量 展开
sql = "SELECT count(id) as countid FROM count where DateDiff('d', time1,now())=0"
else
sql = "SELECT count(id) as countid FROM count where DateDiff(d, time1,getdate())=0"
end if
rs2.Open sql,conn,1,1
if not rs2.eof then
todaycount=rs2("countid")
end if
rs2.close
这是代表今天更新的数据表数量， 目前想获取不是今天与昨天更新的数据表数量 展开
1个回答
展开全部
sql = "SELECT count(id) as countid FROM count where DateDiff(d, time1,getdate())>1" 试试这个
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
