查询本周
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate()),0)

查询两周内
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate())-2,0)

查询上周
(T6.action_timestamp between dateadd(wk,datediff(wk,0,getutcdate()-7),0)

查询本周
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate()),0)

查询两周内
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate())-2,0)

查询上周
(T6.action_timestamp between dateadd(wk,datediff(wk,0,getutcdate()-7),0) and (dateadd(wk,datediff(wk,0,getutcdate()),0))

最佳答案

该回答被楼主/管理员列为正解!

引用:

原帖由 nowo 于 2006-12-20 23:55 发表
查询本周
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate()),0)

查询两周内
(T6.action_timestamp > dateadd(wk,datediff(wk,0,getutcdate())-2,0)

查询上周
(T6.action_timestam ...

这些语句需要放在什么地方呢？？
说明一下 谢谢