小编典典

获取给定日期的正确周数

all

我用谷歌搜索了很多,找到了很多解决方案,但没有一个能给我正确的 2012-12-31 周数。甚至 MSDN
(链接) 上的示例也失败了。

2012-12-31 是星期一,因此应该是第 1 周,但我尝试的每种方法都给了我 53。以下是我尝试过的一些方法:

来自 MDSN 库:

DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar cal = dfi.Calendar;

return cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);

解决方案2:

return new GregorianCalendar(GregorianCalendarTypes.Localized).GetWeekOfYear(date, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);

解决方案3:

CultureInfo ciCurr = CultureInfo.CurrentCulture;
int weekNum = ciCurr.Calendar.GetWeekOfYear(dtPassed, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
return weekNum;

更新

当日期为 2012-12-31 时,以下方法实际上返回 1。换句话说,我的问题是我的方法没有遵循 ISO-8601 标准。

// This presumes that weeks start with Monday.
// Week 1 is the 1st week of the year with a Thursday in it.
public static int GetIso8601WeekOfYear(DateTime time)
{
    // Seriously cheat.  If its Monday, Tuesday or Wednesday, then it'll 
    // be the same week# as whatever Thursday, Friday or Saturday are,
    // and we always get those right
    DayOfWeek day = CultureInfo.InvariantCulture.Calendar.GetDayOfWeek(time);
    if (day >= DayOfWeek.Monday && day <= DayOfWeek.Wednesday)
    {
        time = time.AddDays(3);
    }

    // Return the week of our adjusted day
    return CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(time, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
}

阅读 82

收藏
2022-05-10

共1个答案

小编典典

正如此MSDN
页面
中所述,ISO8601
周数和 .Net 周数之间存在细微差别。

您可以参考 MSDN 博客中的这篇文章以获得更好的解释:“ Microsoft .Net 中的 ISO 8601 Week of Year
format

简而言之,.Net 允许将数周划分为数年,而 ISO 标准则不允许。在文章中还有一个简单的函数可以获取一年中最后一周的正确 ISO 8601 周数。

更新 下面的方法实际上返回 12012-12-31在 ISO 8601(例如德国)中是正确的。

// This presumes that weeks start with Monday.
// Week 1 is the 1st week of the year with a Thursday in it.
public static int GetIso8601WeekOfYear(DateTime time)
{
    // Seriously cheat.  If its Monday, Tuesday or Wednesday, then it'll 
    // be the same week# as whatever Thursday, Friday or Saturday are,
    // and we always get those right
    DayOfWeek day = CultureInfo.InvariantCulture.Calendar.GetDayOfWeek(time);
    if (day >= DayOfWeek.Monday && day <= DayOfWeek.Wednesday)
    {
        time = time.AddDays(3);
    }

    // Return the week of our adjusted day
    return CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(time, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
}
2022-05-10