如何获得一天的开始和结束时间 [英] How to get the start and and end times of a day

问题描述

在我的c＃应用程序中，我传递一个字符串变量，格式为yyyymmdd-yyyymmdd，表示一个从现在开始的日期。我想分别获得这些日期的开始和结束时间。目前我有以下代码，但是想知道是否有更多优雅的解决方案？

所以对于pdr = 20090521-20090523会得到20090521 00:00:00和20090523 23:59:59

  private void ValidateDatePeriod（string pdr，out DateTime startDate，
 out DateTime endDate）
 {
 string [] dates = pdr.Split（' - '）; 
 
如果（dates.Length！= 2）
 {
 throw new Exception（Date period is incorrect format）; 
} 
 
 if（dates [0] .Length！= 8 || dates [1] .Length！= 8）
 {
 throw new Exception拆分日期时间格式不正确）; 
} 
 
 startDate = DateTime.ParseExact（dates [0] +00:00:00，
yyyyMMdd HH：mm：ss，null）; 
 endDate = DateTime.ParseExact（dates [1] +23:59:59，
yyyyMMdd HH :: mm：ss，null）; 
} 
  

解决方案

如果你只是担心.Net精度...

  startDate = DateTime.ParseExact（dates [0]，yyyyMMdd）; 
 endDate = DateTime.ParseExact（dates [1]，yyyyMMdd）。AddTicks（-1）.AddDays（1）; 
  

您真的不需要将额外的值连接到时间部分的字符串。 >

---

作为附录，如果您使用这个查询，例如数据库...

  startDate = DateTime.ParseExact（dates [0]，yyyyMMdd）; 
 endDate = DateTime.ParseExact（dates [1]，yyyyMMdd）。AddDays（1）; 
  

查询...

  WHEREstartDate> = @startDate ANDendDate< @endDate 
  

然后，注释中注明的精度问题并不重要。在这种情况下， endDate 不会是范围的一部分，而是外部边界。

In my c# app, I pass a string variable that is of format yyyymmdd-yyyymmdd that represents a from and to date. I want to get the start and end times for these dates respectively. Currently I have the below code but was wondering if there was more of an elegant solution?

So for pdr = 20090521-20090523 would get "20090521 00:00:00" and "20090523 23:59:59"

private void ValidateDatePeriod(string pdr, out DateTime startDate, 
                                out DateTime endDate)
{
    string[] dates = pdr.Split('-');

    if (dates.Length != 2)
    {
        throw new Exception("Date period is of incorrect format");
    }

    if (dates[0].Length != 8 || dates[1].Length != 8)
    {
        throw new Exception("Split date periods are of incorrect format");
    }

    startDate = DateTime.ParseExact(dates[0] + " 00:00:00", 
        "yyyyMMdd HH:mm:ss", null);
    endDate = DateTime.ParseExact(dates[1] + "23:59:59", 
        "yyyyMMdd HH::mm:ss", null);
}

解决方案

If you are only worried about .Net precision...

startDate = DateTime.ParseExact(dates[0], "yyyyMMdd");
endDate = DateTime.ParseExact(dates[1], "yyyyMMdd").AddTicks(-1).AddDays(1);

You really don't need to concatenate extra values onto the string for the time portion.

---

As an addendum, if you are using this for a query against, for example, a database...

startDate = DateTime.ParseExact(dates[0], "yyyyMMdd");
endDate = DateTime.ParseExact(dates[1], "yyyyMMdd").AddDays(1);

With a query of...

WHERE "startDate" >= @startDate AND "endDate" < @endDate

Then the precision issues noted in the comments won't really matter. The endDate in this case would not be part of the range, but the outside boundary.

这篇关于如何获得一天的开始和结束时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！