The string was not recognized as a valid DateTime, There is an unknown word starting at index 25

Question

I am grabbing a pubDate node from a xml file, Item.PubDate have the date that I grabbed.

NewsItem.Date is my datetime column in my database table column.

But I cant seem to parse it to datetime.

I get "The string was not recognized as a valid DateTime, There is an unknown word starting at index 25"

Item.Pubdate have this value: "Thu, 9 May 2013 05:04:18 PDT"

When I try:

NewsItem.Date = DateTime.Parse(item.PubDate);

I get that error.

How come with other xml files that pubDates it works?

and they have "Thu, 09 May 2013 09:15:11 GMT"?

Is PDT a recognized timezone? http://stackoverflow.com/questions/241789/parse-datetime-with-timezone-of-form-pst-cest-utc-etc — urbanlemur, May 09 '13 at 13:08
You should reject XML files like that, timezone abbreviations are hopelessly ambiguous. There are three distinct "CST" timezones for example. — Hans Passant, May 09 '13 at 13:23

Habib · Accepted Answer · 2013-05-09T13:10:58.227

2

Your string contains PDT (Timezone info), You can't parse with that in your string replace that with empty string and then parse.

NewsItem.Date = DateTime.Parse(item.PubDate.Replace(" PDT",""));

If the string contains GMT then

s contains the Z or GMT time zone designator, and styles includes the RoundtripKind flag. The date and time are interpreted as UTC.

edited May 09 '13 at 13:10

answered May 09 '13 at 13:05

Habib

score 0 · Answer 2 · edited May 23 '17 at 12:29

0

The PDT is not recognised by DateTime.Parse() or Convert.ToDateTime(). But GMT is recognised which is why your second one works.

You need to specify the value that PDT represents.

edited May 23 '17 at 12:29

Community

answered May 09 '13 at 13:10

CathalMF

2 Answers2