Parsing custom format to DateTime

Question

I am trying to convert string to DateTime. Code look as follows:

DateTime.Parse("20131101T210705.282Z").ToShortTimeString()

I am getting format exception.

I tried providing following format "yyyyMMddTssmmhh.fffz" but received same exception. Code looked as follows

DateTime dt;
if (DateTime.TryParseExact("20131101T210705.282Z",
                           "yyyyMMddTssmmhh.fffz",
                          new CultureInfo("en-US"),
                          DateTimeStyles.None,
                          out dt))
    return dt.ToShortTimeString();

In this case code doesn't parse the string.

Sudhakar Tillapudi · Accepted Answer · 2013-11-01 21:41:58Z

1

Try this :

 DateTime dt;
    if (DateTime.TryParseExact("20131101T210705.282Z",
                               "yyyyMMddTssmmhh.fffZ",
                              new CultureInfo("en-US"),
                              DateTimeStyles.None,
                              out dt))
        return dt.ToShortDateString() + " " + dt.ToShortTimeString();

answered Nov 1, 2013 at 21:41

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

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

3 Comments

Darshan Puranik Over a year ago

Did you try this code? I can see our arguments for TryParseExact () are excatly same that means if condition is going to fail.

Sudhakar Tillapudi Over a year ago

i feel that you are giving format in wrong for TryParseExact() as -> 20131101T210705.282Z != yyyyMMddTssmmhh.fffz

Darshan Puranik Over a year ago

Yes i am struggling with format. I made that using the chart provided on MSDN.What is correct format?

Darshan Puranik · Accepted Answer · 2013-11-03 18:41:35Z

0

This might be one way to parse.

   var timeStamp = "20131101T210705.282Z";
   var datetime = timeStamp.Split(new[] { 'T' ,'.'});
   DateTime dt1;


  if (DateTime.TryParseExact(datetime[0],
                     new string[] { "yyyyMMdd" },
                    new CultureInfo("en-US"),
                    DateTimeStyles.None,
                    out dt1))
  {
    Console.WriteLine(dt1.ToShortDateString());
  }

  DateTime dt2;


  if (DateTime.TryParseExact(datetime[1],
                     new string[] { "ssmmhh" },
                    new CultureInfo("en-US"),
                    DateTimeStyles.None,
                    out dt2))
  {
    Console.WriteLine(dt2.ToShortTimeString());
  }

  Console.WriteLine(dt1.ToShortDateString() + " " + dt2.ToShortTimeString());
  Console.ReadLine();

answered Nov 3, 2013 at 18:41

Darshan Puranik

1,0833 gold badges14 silver badges37 bronze badges

1 Comment

Darshan Puranik Over a year ago

Problem with this code is that there is no way to recognize time is AM or PM.

Tim · Accepted Answer · 2013-11-06 16:54:46Z

0

The format was simply incorrect. The timestamp value given doesn't clearly indicate where the hours are since all values (hours, minutes, and seconds) are less than 24. The following code works correctly.

DateTime.TryParseExact(value,
                       "yyyyMMddTHHmmss.fffZ",
                       CultureInfo.InvariantCulture,
                       DateTimeStyles.None,
                       out dt)

Given this proprietary format, the hours are in 24 hour format and come first. A test from this morning yielded the following value: 20131106T162733.032Z. I am able to test this proprietary format because we work for the same company. :)

answered Nov 6, 2013 at 16:54

Tim

2363 silver badges11 bronze badges

Collectives™ on Stack Overflow

Parsing custom format to DateTime

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related