Question

I. C# Data Accessosphere... 我正在检索Excel的一组数据,并且有一个按格式返回的精子外壳:20090701。我需要将其转换为C#Datetime。这样做的最佳方式是什么?

Answer 1

DateTime.ParseExact( value.ToString(), "yyyymmdd" );

http://msdn.microsoft.com/en-us/library/8kb3d4.aspx” rel=“nofollow noreferer”>ParseExact 方法允许你具体说明您转换的日期/时间。您的情况是:四位数字年,然后是两个数字月,然后是两个数字日。

Answer 2

如果你想广泛执行,我会这样做。

System.Globalization.CultureInfo cultureInfo =
            new System.Globalization.CultureInfo("en-CA");
        // Defining various date and time formats.
        dateTimeInfo.LongDatePattern = "yyyyMMdd";
        dateTimeInfo.ShortDatePattern = "yyyyMMdd";
        dateTimeInfo.FullDateTimePattern = "yyyyMMdd";
        // Setting application wide date time format.
        cultureInfo.DateTimeFormat = dateTimeInfo;


    // Assigning our custom Culture to the application.
    //Application.CurrentCulture = cultureInfo;
    Thread.CurrentThread.CurrentCulture = cultureInfo;
    Thread.CurrentThread.CurrentUICulture = cultureInfo;

DateTime.Parse(excelDate);

Answer 3

更不用说对良好措施的直观答案。

var a = 20090701m;
var b = a / 10000;
var year = (int)b;
var c = (b - year) * 100;
var month = (int)c;
var day = (int)((c - month) * 100);
var dt = new DateTime(year, month, day);

友情链接