DateTime.ParseExact format string

Question

I have a web application that passes a DateTime from one page to another through the query string. It was working just fine in both IE and FireFox, but was throwing exceptions whenever I tried it in Google Chrome. The program is choking on the following line:

startDateTime = Convert.ToDateTime(Request.QueryString["start"]);

So, I ran the debugger and found that the value in the query string is:

Wed Oct 03 2012 08:00:00 GMT-0400 (Eastern Daylight Time)

I concluded that Convert just wasn't up to the job and set about trying to get DateTime.ParseExact to tame this beast. But, so far the correct format string has eluded me. Here's the code that I've been trying (which doesn't work):

DateTime.ParseExact(Request.QueryString["start"], "ddd MMM dd yyyy HH:mm:ss zzz", CultureInfo.InvariantCulture);

This page is being called from another page through some JavaScript that is called by a third-party component (DayPilotCalendar). Here is the relevant property that is set on the DayPilotCalendar control:

TimeRangeSelectedJavaScript="GB_showPage('Request Magnet Time', '../../../EventAddEdit.aspx?start=' + encodeURIComponent(start) + '&end=' + encodeURIComponent(end))"

What is wrong with my format string?

What format to you want the result string to be in? ie. 09/12/2012 or Sept 12 2012 etc. — Jordan Kaye
– Jordan Kaye, Commented Oct 1, 2012 at 14:40
@JordanKaye, the result should be a DateTime instance, not string. So there's really no format involved for the output. — Darin Dimitrov
– Darin Dimitrov, Commented Oct 1, 2012 at 14:40
This doesn't seem to be any of the standard formats. Can you change the caller of your page to use some of the standard formats? Such as ISO 8601 for example. — Darin Dimitrov
– Darin Dimitrov, Commented Oct 1, 2012 at 14:49
Is the "Wed Oct 03 2012 08:00:00 GMT-0400 (Eastern Daylight Time)" from JS or from C#? — aquinas
– aquinas, Commented Oct 1, 2012 at 14:58

aquinas · Accepted Answer · 2012-10-01 16:21:22Z

4

Might I suggest that instead of passing something like: "Wed Oct 03 2012 08:00:00 GMT-0400 (Eastern Daylight Time)" in your query string, that instead you simply pass the timestamp of the date? E.g., new Date().getTime(). (Number of milliseconds since 1970 in UTC). Then, in C# you could just do:

var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
var dt =  epoch.AddMilliseconds(Convert.ToInt64(Request.QueryString["start"]));

No parsing required.

edited Oct 1, 2012 at 16:21

answered Oct 1, 2012 at 14:54

aquinas

23.9k5 gold badges60 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rawling · Accepted Answer · 2012-10-01 14:59:55Z

3

It may just be that your format doesn't cover the (Eastern Daylight Time) section. Try parsing that out of your string using regular string handling methods, then calling ParseExact on the remainder.

Edit: As Oded points out, you'll also have to put the GMT into your format string as a literal:

"ddd MMM dd yyyy HH:mm:ss 'GMT'zzz"

The following works:

var input = "Wed Oct 03 2012 08:00:00 GMT-0400 (Eastern Daylight Time)";
var trim = input.Substring(0, input.IndexOf(" ("));
var dt = DateTime.ParseExact(
    trim,
    "ddd MMM dd yyyy HH:mm:ss 'GMT'zzz",
    CultureInfo.InvariantCulture);

edited Oct 1, 2012 at 14:59

answered Oct 1, 2012 at 14:46

Rawling

50.3k7 gold badges94 silver badges131 bronze badges

3 Comments

Oded Over a year ago

The GMT will give problems as well.

Matt Over a year ago

Sorry to reneg on the accept for your answer. Your code works, but I ended up going with the solution suggested by aquinas, as it seems that it is likely to be more robust.

Rawling Over a year ago

Well yes, if you've got control of what's generating the string, that makes much more sense...

Mr. Polywhirl · Accepted Answer · 2015-01-15 16:43:18Z

0

I tried running the code

static void Main(string[] args) {
    Console.WriteLine(DateTime.Now.ToString("ddd MMM dd yyyy HH:mm:ss zzz"));            
    Console.Read();
}

Output is :

Mon Oct 01 2012 10:52:20 -04:00

So I guess you need to parse the GMT and (Eastern Daylight Time) part of strings as well

edited Jan 15, 2015 at 16:43

Mr. Polywhirl

49.1k12 gold badges96 silver badges147 bronze badges

answered Oct 1, 2012 at 14:53

PReghe

111 bronze badge

Collectives™ on Stack Overflow

DateTime.ParseExact format string

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related