Convert String To Datetime e.g. "10/1/19 4:19:38 AM UTC"

Question

I need to convert this string to DateTime: "10/1/19 4:19:38 AM UTC"

I have tried the below and get various errors.

CultureInfo provider = CultureInfo.InvariantCulture;
DateTime.ParseExact(value.ToString(), "MM/dd/yy hh:mm:ss tt KKK", provider);
DateTime.ParseExact(value.ToString(), "MM/dd/yy hh:mm:ss t K", provider)

this is different from Parse DateTime with time zone of form PST/CEST/UTC/etc as it is parsing an alpha month name

use only one d for day and one h for hour. When you use one it will accept either one or two digits. When you use two it will only accept two. — jdweng, Oct 02 '19 at 16:52
You can't parse this because "UTC" is not recognized as a valid parameter. — Mitulát báti, Oct 02 '19 at 16:57
To echo Mitulat - you'll need to either strip off the UTC or convert it to a time zone (e.g. `"+00:00"`) — D Stanley, Oct 02 '19 at 17:01
`"MM/d/yy h:mm:ss tt UTC"` or `"MM/d/yy h:mm:ss tt 'UTC'"` will parse as long as UTC is always in the string — haldo, Oct 02 '19 at 18:51

score 1 · Answer 1 · answered Oct 02 '19 at 17:00

1

"UTC" is something that can't be parsed. You should use e.g. "+02:00" as a time zone indicator.

Remove the "UTC" from the end, after that go with this format:

"M/d/yy h:m:s tt".

Or change "UTC" to "+02:00" and use this format:

"M/d/yy h:m:s tt K"

answered Oct 02 '19 at 17:00

Mitulát báti

2,086
5
23
37

Z can probably be parsed – Joe Phillips Oct 02 '19 at 17:07

Convert String To Datetime e.g. "10/1/19 4:19:38 AM UTC"

1 Answers1