sql如何查询当天数据？
有个表里有个字段为addtime，精确到秒，就是检索出24小时之内的信息。
datediff(day,addtime,getdate())=0
SQL code:
ABS(datediff(DD,addtime,getdate()))=0
SQL code:
datediff(hh,col,dateadd(dd,1,col))=24
SQL code:
select * from tb where datediff(ss,addtime,getdate())>=24*60*60
不行啊。怪我没说清楚。
select count(ID) as num2 from test where Article_Id="&id&" order by ???
----
是这个语句怎么判断addtime为24小时内的数据啊。
select * from tb where datediff(ss,addtime,getdate())>=24*60*60
SQL code:
select count(ID) as num2 from test where Article_Id="&id&"
and addtime between DATEADD(day,-1,getdate()) and GETDATE()
order by ???
SQL code:
Select GETDATE(),DATEADD(day,-1,getdate())
/*
----------------------- -----------------------
2009-11
相关问答：
大家帮忙看看这2个sql语句哪个查询的速度更快点。谢谢帮忙。比较着急。在做性能测试。
select * from
表A LEFT OUTER JOIN 表B ON (表A.id || ' ' =表B.id) ,表C , 表D, 表E
Where其他条件
select * ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
小弟我用ADO连接SQL server 2000数据库，然后在DBGrid中显示，现在想把在DBGrid中查询到的数据iPlot作图，请问如何实现在DBGrid中的数据读取，读出的数据是STRING类型的，如何有效的转变成数据库中所存储的DOUBLE类� ......
