Question

I have a database script that returns date time string and my problem is that I don t know what format my string will be. The reason is that I have desktop in different culture and they could return any kind of format. My ultimate goal is, from the string to return the DateTime. As I am trying to write something I am realizing that I would need to try any kind of format to make sure something comes back to me without an exception. There should be a better way to do this without trial and error. This is what I have but it only works for a few formats:

    public static DateTime FromQueryResultString(string dttmString)
    {
        string[] formats = { "dd/MM/yyyy", "yyyy-MM-dd HH:mm:ss", "dd/MM/yyyy HH:mm:ss", "yyyyMMdd HH:mm:ss", "dd.MM.yy hh:mm", "M/d/yy h:mm tt", "ddd MMM dd H:mm:ss yyyy", "dd.MM.yy hh:mm", "dd.MM.yy HH:mm","ddd MMM yy H:mm:ss yyyy" };

        string name = Thread.CurrentThread.CurrentCulture.Name;
        IFormatProvider format = new CultureInfo(name, false);
        DateTime formattedDate = DateTime.ParseExact(dttmString, formats, format, DateTimeStyles.None);
    }

Answer 1

我认为,你没有基本概念。

考虑到你再次谈论数据基,它是一种文字,I immagine,它从数据库上获取数据。页: 1 在这种情况下,你将有一个单一的稳定的数据存取层,它将回收并操纵从罗马、巴黎、北京或阿布扎比收集的数据。 The client program that data will pornography/em> in culture Depend way.

简言之,选择一种格式并以这种方式储存。

很显然,这一结构不可能有always<>em>,但从一成不变,在99%的案例中是可能的。

希望这一帮助。

Answer 2

为此:

DateTime parsedDate;

if(DateTime.TryParse(dttmString, parsedDate)) 
{ 
      //TODO
}

Answer 3

你们可以通过。然后,你可以从文化信息归还物财产日价获得日期。这意味着Windows处理它,而你不需要做任何特殊手工操作。

EDIT:Sample Code

public static DateTime FromQueryResultString(string dttmString) 
{ 
    string[] formats = { "dd/MM/yyyy", "yyyy-MM-dd HH:mm:ss", "dd/MM/yyyy HH:mm:ss"
    IFormatProvider format = Thread.CurrentThread.CurrentCulture.DateTimeFormat;
    DateTime formattedDate = DateTime.ParseExact(dttmString, formats, format, System.Globalization.DateTimeStyles.None);
}

友情链接