Need to convert this string: Mon Oct 31 16:18:15 CDT 2011
Into a valid DateTime value.
Have tried every variation of the date time styles with DateTime.Parseto no avail.
Any ideas?
Asked
Active
Viewed 771 times
1
JohnFx
- 34,542
- 18
- 104
- 162
user569963
- 31
- 3
-
Are you concerned with converting between time zones or are you assuming the timezone in the string is the local one? – JohnFx Jan 23 '12 at 22:00
-
Actually just want to extract a valid date / time and ignore the Day and time zone as this will be useds as a timestamp. – user569963 Jan 23 '12 at 22:05
-
Is the timezone always CDT? Or will this change? I understand that you want this ignored? – Oded Jan 23 '12 at 22:13
-
will always be central US time, could be daylight or standard – user569963 Jan 23 '12 at 22:16
-
Check http://stackoverflow.com/questions/2961848/how-to-use-timezoneinfo-to-get-local-time-during-daylight-savings-time – Peter Arandorenko Jan 23 '12 at 22:35
1 Answers
3
The problem is with the CDT you have there. This is not a valid portion of a string representing a DateTime.
You may have luck with replacing this with a valid representation of a timezone -0500 and the K format specifier for it.
You can use the following format string to parse the string:
ddd MMM dd HH:mm:ss CDT yyyy
For instance:
DateTime.ParseExact("Mon Oct 31 16:18:15 CDT 2011",
"ddd MMM dd HH:mm:ss CDT yyyy",
CultureInfo.InvariantCulture);
I suggest reading the documentation for Custom Date and Time Format Strings on MSDN.
Oded
- 489,969
- 99
- 883
- 1,009
-
Yeah you will have to replace that CDT with the offset as Oded has said. – Jeremy Jan 23 '12 at 22:04
-
-
@user569963 - Note that `ParseExact` will throw an exception if not successful. There is a `TryParseExact` that will not throw an exception but return a boolean value indicating success or failure. – Oded Jan 23 '12 at 22:52