sql-server如何返回一个星期内开户的卡号

[liujianliang]

table1

cardID openDate
--------------------------
123 2007-12-1
234 2007-12-2
345 2007-11-15

[dawugui]

select * from tb where datediff(week,opendate,getdate()) = 0

[dawugui]

create table tb (cardID int , openDate datetime)
insert into tb values(123,               '2007-12-1') 
insert into tb values(234,               '2007-12-2') 
insert into tb values(345,               '2007-11-15') 
go

select * from tb where datediff(week,opendate,getdate()) = 0

drop table tb

/*
cardID      openDate                                               
----------- ------------------------------------------------------ 
234         2007-12-02 00:00:00.000

（所影响的行数为 1 行）
*/

[中国风]

select * from tb where openDate>dateadd(dd,-7,getdate())

[中国风]

select * from tb where datediff(dd,openDate,getdate())<7--7天内

[rouqu]

接分