我通过文本文件以以下形式收到字符串,这是通过SSIS包传输的:
"20090910" (string)
它需要被这样做。
2010-09-01 00:00:00 (Date)
任何建议?
使用你的数据,以下是来自MSDN的示例:
Dim dateString, format As String
Dim result As Date
Dim provider As Globalization.CultureInfo = Globalization.CultureInfo.InvariantCulture
' Parse date and time with custom specifier.
dateString = "20090910"
format = "yyyyMMdd"
Try
result = Date.ParseExact(dateString, format, provider)
Console.WriteLine("{0} converts to {1}.", dateString, result.ToString())
Console.ReadLine()
Catch e As FormatException
Console.WriteLine("{0} is not in the correct format.", dateString)
End Try