请问如何查询离当天7天的记录

[mingjunwang]

请问如何查询离当天7天人记录
如：
id appdate pname
1 2010-4-1 A1
2 2010-4-2 A2
3 2010-4-3 A3
4 2010-4-4 A4
5 2010-4-5 A5
6 2010-4-6 A6
7 2010-4-7 A7
8 2010-4-8 A8
9 2010-4-9 A9
.....
若今天是8号，那就要把id为1到7的记录查出。用select * from tbname where (getdate()-appdate)='7' ,这样可以吗？

[htl258_Tony]

[Quote=引用 7 楼 htl258 的回复:]
SQL code
select * from tb where appdate between getdate()-7 and getdate()-1


如果appdate没有时分秒，可以这样。
[/Quote]

select * from tb where appdate between convert(varchar,getdate()-7,23) and convert(varchar,getdate()-1,23)

7楼修改，代码不够严密。

[QQHRSWB]

select * from tbname where convert(char(8),appdate,112) <= 7 convert(char(8),getdate()-1,112) ,取整7天的

[fan7421436]

学习··

[hbjlwhl]

一定可以的。但是你写的不对。

[无锡阔微信息科技]

select * from tbname where datepart(day,getdate())-datepart(day,appdate)=7

[sxiaohui8709253]

学习，，，

[lrjt1980]

用特殊日期函数。

[wqmgxj]

select * from tb where datediff(dd,appdate,getdate())<=7

[QQHRSWB]

写错了，重来
select * from DBNAME
where convert(char(8),APPDATE,112) BETWEEN convert(char(8),GETDATE()-7,112) AND convert(char(8),GETDATE()-1,112)

[cnfuyou]

select * from #tt where appdate < dateadd(day,-1,getdate()) and appdate >dateadd(day,-8,getdate())

[ycagri]

我也不推荐在列上使用函数，这样索引就不起作用了
最好是采用 between and方式

[ontrackfor19888]

学习了
！！！

[beifengchuiqi]

上面都说了。。

[Leshami]

select * from tbname where appdate >= getdate() - 7

[tanshi]

SELECT * FROM table
WHERE appdate
between CONVERT(varchar,year(getDate()))+'-'+CONVERT(varchar,month(getDate()))+'-'+CONVERT(varchar,day(getDate())-7)
	and CONVERT(varchar,year(getDate()))+'-'+CONVERT(varchar,month(getDate()))+'-'+CONVERT(varchar,day(getDate()))

[cxmcxm]

直接两个日期相关肯定不行
应用datediff函数计算两日期相差的天数

[baobeituping]

select * from tb where datediff(dd,appdate,getdate())<=7

[zhuoruling]

差不多，顶个

[ablihui3]

select * from tb where appdate > ADDDATE(getdate(),-7);

[ablihui3]

select * from tb where appdate > ADDDATE(now(),-7);