sqlserver查询本周、上周、今天、昨天数据

最新推荐文章于 2024-08-06 17:03:59 发布

write less,do more

最新推荐文章于 2024-08-06 17:03:59 发布

阅读量3.4k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_41373328/article/details/90107131

版权

数据库专栏收录该内容

19 篇文章 0 订阅

订阅专栏

--本周
select * from CompletScan where CONVERT(datetime,ScanDate,101)>=DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 0) 
and CONVERT(datetime,ScanDate,101)<DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 7);
--上周
select * from CompletScan where CONVERT(datetime,ScanDate,101)>=dateadd(week,-1,DATEADD(week,DATEDIFF(week,0,getdate()),0)) 
and CONVERT(datetime,ScanDate,101)<dateadd(week,-1,DATEADD(week,DATEDIFF(week,0,getdate()),7));
--今天
SELECT * FROM CompletScan where DATEDIFF(day,CONVERT(datetime,ScanDate,101),GETDATE())=0;
--昨天
SELECT * FROM CompletScan where DATEDIFF(day,CONVERT(datetime,ScanDate,101),GETDATE())=1;