Convert String to DateTime Format

Question

I am getting a date and time from a data feed which I cannot change, and I need to convert it to a DateTime.

The format of the string is as follows.

timestamp="20131204T171054+0000"

Answer 1

You could use DateTime.ParseExact and specify a Custom Date and Time Format String.

Your sample looks like "yyyyMMddTHHmmssK" might work.

In vb.net

Dim timestamp As String = "20131204T171054+0000"
Dim dt As DateTime = DateTime.ParseExact(timestamp, "yyyyMMddTHHmmssK", CultureInfo.InvariantCulture)

In C#

string timestamp = "20131204T171054+0000";
DateTime dt = DateTime.ParseExact(timestamp, "yyyyMMddTHHmmssK", CultureInfo.InvariantCulture);