SQL Server获取上周一与周日的数据

--上周一
select dateadd(week,-1,DATEADD(week,DATEDIFF(week,0,getdate()),0))
--上周日
select dateadd(week,-1,DATEADD(week,DATEDIFF(week,0,getdate()),6))

 

posted @ 2023-06-09 15:04  它的眼角开过光  阅读(428)  评论(0编辑  收藏  举报