在SQL查询中，我要用到当前日期减去一个星期，要怎样做呢？谢谢，急急！！

Question

select PoNo,CODE,Description],Color,Quantity,Staff,OrderDate,DeliveryDate
from AAAbroadDetail where orderdate>(dateadd(wk,-1,getdate())
select  dateadd(month,-24,'2002-12-14')
---------------------^^^减
select  dateadd(day,-24,'2002-12-14')
----------------^^^天或year年

Answer 1

如果差7天的不是一周话，应该用
dateadd(d，-7,getdate() 判断或
datediff(d,orderdate,getdate()) < 7

Answer 2

select PoNo,CODE,Description],Color,Quantity,Staff,OrderDate,DeliveryDate
from AAAbroadDetail where datediff(dd,orderdate,getdate())<7

Answer 3

出现如下错误：
Server: Msg 156, Level 15, State 1, Procedure usp_AAAbordDetail_GetRecently, Line 4
Incorrect syntax near the keyword 'order'.我的OrderDate的类型是smalldatetime

Answer 4

试试:alter proc usp_AAAbordDetail_GetRecentlyasselect PoNo,CODE,Description],Color,Quantity,Staff,OrderDate,DeliveryDate
from AAAbroadDetail where dateadd(week,orderdate,getdate())=1
GOexec usp_AAAbordDetail_GetRecently

Answer 5

同样也不可以，但错误如下：
Server: Msg 8116, Level 16, State 1, Procedure usp_AAAbordDetail_GetRecently, Line 3
Argument data type smalldatetime is invalid for argument 2 of dateadd function.

Answer 6

UP  UP  UP  !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!