SQL查看最近一周的数据
select * from table WHERE id=1and (DATEPART(wk, CONVERT(varchar(10),getDate(),120)) = DATEPART(wk, GETDATE())) AND (DATEPART(yy, CONVERT(varchar(10),getDate(),120)) = DATEPART(yy, GETDATE()))
SQL查看最近一周的数据
select * from table WHERE id=1and (DATEPART(wk, CONVERT(varchar(10),getDate(),120)) = DATEPART(wk, GETDATE())) AND (DATEPART(yy, CONVERT(varchar(10),getDate(),120)) = DATEPART(yy, GETDATE()))