在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
DateTime dt = DateTime.Now; //当前时间
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一 DateTime endWeek = startWeek.AddDays(6); //本周周日 DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初 DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末 //DateTime endMonth = startMonth.AddDays((dt.AddMonths(1) - dt).Days - 1); //本月月末 DateTime startQuarter = dt.AddMonths(0 - (dt.Month - 1) % 3).AddDays(1 - dt.Day); //本季度初 DateTime endQuarter = startQuarter.AddMonths(3).AddDays(-1); //本季度末 DateTime startYear = new DateTime(dt.Year, 1, 1); //本年年初 DateTime endYear = new DateTime(dt.Year, 12, 31); //本年年末 SQL版本:
select dateadd(day, 2 - datepart(dw,getdate()), getdate()) [星期一],dateadd(day, 8 - datepart(dw,getdate()), getdate()) [星期日]
|
请发表评论