新手求助!

Question

表1
  F_id      F_name           F_booktime
  1         aa               2006-10-30想查询出7天内的信息

Answer 1

select *
from 表名
where datediff(day,日期字段,getdate())<7

Answer 2

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

Answer 3

select *
from tablename
where (getdate()-F_booktime)<7

Answer 4

select * from tablename where f_booktime between  rq   and dataadd(dd,-6,rq)
其中 rq 是你想要的起始日期

Answer 5

datediff(day,日期字段,getdate())<7

Answer 6

楼主< and > /between/datediff取范围都行