我如何将日期时间归档转换为数字格式 [英] How could i datetime filed convert to number format

问题描述

我如何将日期时间归档转换为数字格式

例如:

How could i datetime filed convert to number format

e.g:

DateTime StartOfWeek = DateTime.Today.AddDays(-(int)DateTime.Today.DayOfWeek);
      DateTime EndOfLastWeek = StartOfWeek.AddDays(-1);

谢谢
Tamimun

Thanks
Tamimun

推荐答案

尝试以下操作:

Try this: From this link[^]

public static int Weekdays(DateTime dtmStart, DateTime dtmEnd)
    {
        // This function includes the start and end date in the count if they fall on a weekday
        int dowStart = ((int)dtmStart.DayOfWeek == 0 ? 7 : (int)dtmStart.DayOfWeek);
        int dowEnd = ((int)dtmEnd.DayOfWeek == 0 ? 7 : (int)dtmEnd.DayOfWeek);
        TimeSpan tSpan = dtmEnd - dtmStart;
        if (dowStart <= dowEnd)
        {
            return (((tSpan.Days / 7) * 5) + Math.Max((Math.Min((dowEnd + 1), 6) - dowStart), 0));
        }
        return (((tSpan.Days / 7) * 5) + Math.Min((dowEnd + 6) - Math.Min(dowStart, 6), 5));
    }

测试(每个测试返回5):

Tests (each test returns 5):

int ndays = Weekdays(new DateTime(2009, 11, 30), new DateTime(2009, 12, 4));
   System.Console.WriteLine(ndays);

   // leap year test
   ndays = Weekdays(new DateTime(2000, 2,27), new DateTime(2000, 3, 5));
   System.Console.WriteLine(ndays);

   // non leap year test
   ndays = Weekdays(new DateTime(2007, 2, 25), new DateTime(2007, 3, 4));
   System.Console.WriteLine(ndays);

这对您来说应该很好

This should work fine for you

DateTime date = DateTime.Now;
long dateAsLong = date.ToFileTime();
DateTime orgDate = DateTime.FromFileTime(dateAsLong);

或

Or

DateTime mydate = new DateTime( 1970, 1, 1, 0, 0, 0, 0 );
long mL64 = mydate.Ticks;

这篇关于我如何将日期时间归档转换为数字格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！