关于DateTime操作

最新推荐文章于 2023-09-11 16:26:58 发布

weixin_30659829

最新推荐文章于 2023-09-11 16:26:58 发布

阅读量98

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/opts/p/7365456.html

本文介绍了如何使用C#进行日期的计算，包括获取指定月份的第一天和最后一天的方法。此外，还展示了如何利用SQL进行时间格式的数据校验及按不同时间维度（如日、周、月）对数据进行分组统计。

int month = month - DateTime.Now.Month;
startTime = DateTime.Today.AddDays(0 - DateTime.Today.Day + 1).AddMonths(month); //当月第一天
endTime = DateTime.Today.AddDays(1 - DateTime.Today.Day).AddMonths(month + 1).AddDays(-1); //当月最后一天

校验字符串是否是时间格式

输入： 19941011

输出： true

DateTime dt;
IFormatProvider ifp = new CultureInfo("zh-CN", true);
if (!DateTime.TryParseExact(dateString, "yyyyMMdd", ifp, DateTimeStyles.None, out dt))
{

　　result =true

}

select DATE_FORMAT(CreatedAt,'%m,%d') StatisticsKey,count(FID) StatisticsValue from ruiec_newcloud_blogcenter.t_blog_demand group by StatisticsKey;

select DATE_FORMAT(CreatedAt,'%d') days,count(FID) StatisticsValue from ruiec_newcloud_blogcenter.t_blog_demand where CreatedAt between {0} and {1} group by days

select DATE_FORMAT(CreatedAt,'%d') days,count(FID) count from ruiec_newcloud_blogcenter.t_blog_demand where CreatedAt between '2017-07-01' and '2017-07-31' group by days;

select DATE_FORMAT(CreatedAt,'%Y%u') weeks,count(FID) count from ruiec_newcloud_blogcenter.t_blog_demand where CreatedAt between '2017-08-01' and '2017-08-31' group by weeks;

select DATE_FORMAT(CreatedAt,'%m') months,count(FID) count from ruiec_newcloud_blogcenter.t_blog_demand group by months;

转载于:https://www.cnblogs.com/opts/p/7365456.html