c#日期数据

一、C#

• 本周周一

  var dateTime = DateTime.Today.AddDays(1 - Convert.ToInt32(DateTime.Today.DayOfWeek.ToString("d"))).ToString("yyyy/MM/dd");

• 前5周的周一

  var dateTime = DateTime.Today.AddDays(-28).AddDays(1 - Convert.ToInt32(DateTime.Today.DayOfWeek.ToString("d"))).ToString("yyyy/MM/dd");

• 本周是今年的第几周

   int week = int.Parse(((DateTime.Today.DayOfYear + Convert.ToInt32(Convert.ToDateTime(DateTime.Today.ToString("yyyy") + "/01" + "/01").DayOfWeek) - 1) / 7 + 1).ToString());

• 本月有几天

     int days = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month);

• 本月第一天是周几

 var first = 8 - Convert.ToInt32(Convert.ToDateTime(DateTime.Today.ToString("yyyy") + "/01" + "/01").DayOfWeek);

• 本月有几周

//本月天数
int days = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month);
//本月第一天是周几
var first = 8 - Convert.ToInt32(Convert.ToDateTime(DateTime.Today.ToString("yyyy") + "/01" + "/01").DayOfWeek);
//本月有几周
var date = first == 7 ? days % 7 == 0 ? days / 7 : days / 7 + 1 : (days - first) % 7 == 0 ? (days - first) / 7 : (days - first) / 7 + 1;

• 本月的第一个周一

var first = Convert.ToInt32(Convert.ToDateTime(DateTime.Now.Year + "/" + DateTime.Now.Month + "/01").DayOfWeek);
var weekDay = DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + (first == 1 ? "1" : (9 - first).ToString());

• 本月第一天

DateTime.Now.AddDays(1 - DateTime.Now.Day).Date
//结果：2022-10-01 00:00:00.000

• 本月最后一天

DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1)
//结果：2022-10-31 00:00:00.000

二、Sql

• sql 本月第一天

select  DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)
//结果： 2022-10-01 00:00:00.000

• sql 本月最后一天

select  DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE()), -1)
//结果：2022-10-31 00:00:00.000