产品使用及交流论坛

首页 » 产品使用交流区 » 安装及使用交流 » xiyou帮我看下datediff是什么问题
hbdadao - 2014/4/9 11:15:54
<html>
<head>
<style type="text/css">
div{font:12px/1.7em Verdana,Tahoma,Helvetica,Arial,sans-serif;}
div .hs{color:#ff0000}
</style>
</head>
<body bgColor="transparent">
<div>
○- 文章总数:<span class="hs"><%=Get_Data("co","select count(id) as co from article")%></span><br>
○- 今日文章:<span class="hs"><%=Get_Data("co","select count(id) as co from article where datediff('day',thedate,GETDATE())=0")%></span><br>
○- 会员总数:<span class="hs"><%=Get_Data("co","select count(id) as co from pa_member")%></span><br>
○- 最新会员:<span class="hs"><%=Get_Data("username","select top 1 username from pa_member order by id desc")%></span><br>
○- 访问总数:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count")%></span><br>
○- 本月访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff('m',thedate,GETDATE())=0")%></span><br>
○- 今日访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff('day',thedate,GETDATE())=0")%></span><br>
</div>
</body>
</html>
xiyou - 2014/4/9 12:06:55
你是用sql吗?如果使用sql
datediff('m' , datediff('day'这些地方不要带单引号,这是access数据库的写法
sql按下面方式修改
datediff('m' 改为datediff(month
datediff('day'改为datediff(day
hbdadao - 2014/4/10 11:04:52
:rose谢谢xiyou搞定了
1
查看完整版本: xiyou帮我看下datediff是什么问题