110,536
社区成员
发帖
与我相关
我的任务
分享
--SQL 中直接轉換的結果是
select convert(datetime,'Aug 1 2007 12:05:12:000AM')
/*
-------------------------
2007-08-01 00:05:12.000
*/
DateTime dt1 = DateTime.ParseExact("Aug 31 2007 12:05:12:000AM", "MMM d yyyy hh:mm:ss:ffftt", CultureInfo.GetCultureInfo("en-US"));
DateTime dt2 = DateTime.ParseExact("Aug 31 2007 12:05:12:000PM", "MMM d yyyy hh:mm:ss:ffftt", CultureInfo.GetCultureInfo("en-US"));
MessageBox.Show(dt1.ToString("yyyy-MM-dd HH:mm:ss:fff") + "\n" + dt2.ToString("yyyy-MM-dd HH:mm:ss:fff"));
"MMM d yyyy hh:mm:ss:ffftt"
"Aug 31 2007 12:05:12:000PM" //2007-8-31 12:05:12
"Aug 31 2007 12:05:12:000AM" //2007-8-31 0:05:12
DateTime dt = DateTime.ParseExact("Aug 1 2007 12:05:12:000AM", "MMM d yyyy hh:mm:ss:ffftt", CultureInfo.GetCultureInfo("en-US"));
MessageBox.Show(dt.ToString("yyyy-MM-dd HH:mm:ss:fff"));
DateTime vDateTime = DateTime.ParseExact("Aug 1 2007 12:05:12:000AM",
"MMM d yyyy HH:mm:ss:ffftt",
System.Globalization.DateTimeFormatInfo.InvariantInfo);
Console.WriteLine(vDateTime);
DateTime dt = DateTime.ParseExact("Aug 1 2007 12:05:12:000AM", "MMM d yyyy HH:mm:ss:ffftt", CultureInfo.GetCultureInfo("en-US"));
MessageBox.Show(dt.ToString("yyyy-MM-dd HH:mm:ss:fff"));