C#/SQL 上周本周

DateTime dt = DateTime.Now;  //当前时间
int dayOfWeek = Convert.ToInt32(dt.DayOfWeek.ToString("d"));
DateTime weekStart = dt.AddDays(1 - ((dayOfWeek == 0) ? 7 : dayOfWeek));   //本周周一
DateTime weekEnd = weekStart.AddDays(6);  //本周周日
DateTime lastWeekStart = weekStart.AddDays(-7);  //上周周一
DateTime lastWeekEnd = weekEnd.AddDays(-7);  //上周周日

 

select dateadd(d,-7,DATEADD(wk,DATEDIFF(wk,0,getdate()),0))
select dateadd(d,0,DATEADD(wk,DATEDIFF(wk,0,getdate()),0))
SELECT CONVERT(varchar(10),GETDATE()-DATEPART(day,GETDATE())+1,120)
SELECT DATEADD(day,-1,DATEADD(month,1,CONVERT(varchar(10),GETDATE()-DATEPART(day,GETDATE())+1,120)))

 

SELECT DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE())-1,0)
SELECT DATEADD(DAY,-1,DATEADD(DAY,1-DATEPART(DAY,GETDATE()),GETDATE()))