Parse Datetime string

Question

I'm trying to convert the following string to datetime. I've searched high and low and can't find the exact formats string and I don't want to resort to parsing it manually.

var dateString = "20110828T134108+0100";

All my attempts fail with FormatException.

I tried first to remove the timezone so the string became "20110828T134108" and tried DateTime.ParseExact(dateString, "yyyyMMdd'T'hhmmss",null) but with no luck — marto
– marto, Commented Feb 24, 2012 at 16:36

linepogl · Accepted Answer · 2012-02-24 16:35:35Z

3

Have you tried this?

var date = DateTime.ParseExact( dateString
   ,"yyyyMMdd\THHmmsszzz"
   ,CultureInfo.InvariantCulture 
   );

From MSDN:

If format is a custom format pattern that does not include date or time separators (such as "yyyyMMdd HHmm"), use the invariant culture for the provider parameter and the widest form of each custom format specifier. For example, if you want to specify hours in the format pattern, specify the wider form, "HH", instead of the narrower form, "H".

answered Feb 24, 2012 at 16:35

linepogl

9,3854 gold badges36 silver badges45 bronze badges

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

Comments

TimW · Accepted Answer · 2012-02-24 16:29:52Z

0

The documentation on the format string is here: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

That should get you started. :)

answered Feb 24, 2012 at 16:29

TimW

731 silver badge6 bronze badges

Comments

vulkanino · Accepted Answer · 2012-02-24 16:32:01Z

0

try this format: "yyyyMMdd'T'HHmmss"

answered Feb 24, 2012 at 16:32

vulkanino

9,1347 gold badges47 silver badges73 bronze badges

Comments

Dan · Accepted Answer · 2012-02-24 16:36:05Z

0

Have you tried this:

DateTime.ParseExact("20110828T134108+0100", "yyyyMMdd'T'HHmmsszzzz", CultureInfo.InvariantCulture);

answered Feb 24, 2012 at 16:36

Dan

5,6978 gold badges50 silver badges75 bronze badges

Collectives™ on Stack Overflow

Parse Datetime string

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related