Parsing a DateTimeOffset string in C#

Question

I need parse datetimeoffsets from strings of multiple formats. One of the strings that fail is: 08/12/1992 07.00.00 -05:00

Now when I try to parse this, I use:

DateTimeOffset.ParseExact("08/12/1992 07.00.00 -05:00", "dd/MM/yyyy HH:mm:ss zzz", CultureInfo.InvariantCulture)

Which gives a FormatException:

"String was not recognized as a valid DateTime."

I can also try to add delimiters in the separators:

DateTimeOffset.ParseExact("08/12/1992 07.00.00 -05:00", "dd'/'MM'/'yyyy HH':'mm':'ss zzz", CultureInfo.InvariantCulture)

...or other permutations of small/capital letter or separators, but I get the same error.

Can anyone tell me why the ParseExact lines above do not work, and how to correct them?

EDIT: I tried using a LINQ query to replace the colon with dots (: -> .). Apparently that did not work correctly - thanks for the replies.

That doesn't look like a culture invariant date time string. — juharr
– juharr, Commented Sep 28, 2015 at 14:42

Christian.K · Accepted Answer · 2015-09-28 13:35:35Z

10

Your actual date (actually time) string delimits the hours from the minutes from the seconds with a dot ., so your format must do the same:

DateTimeOffset.ParseExact("08/12/1992 07.00.00 -05:00", 
    "dd/MM/yyyy HH.mm.ss zzz", CultureInfo.InvariantCulture)
//                ^  ^
//                |  |

If you have multiple string formats in your data, you can do something like this:

    public static DateTimeOffset Parse(string str)
    {
        string[] formats =
        {
            "dd/MM/yyyy HH.mm.ss zzz",
            "dd/MM/yyyy HH:mm:ss zzz"
            // ... possibly more ...
        };

        var dto = new DateTimeOffset();
        if (!formats.Any(f => DateTimeOffset.TryParseExact(str, f, CultureInfo.InvariantCulture, DateTimeStyles.None, out dto)))
        {
            throw new ArgumentException("Unrecognized date format");
        }

        return dto;
    }

edited Sep 28, 2015 at 13:35

answered Sep 28, 2015 at 13:27

Christian.K

49.6k10 gold badges108 silver badges155 bronze badges

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

Comments

Codor · Accepted Answer · 2015-09-28 13:28:24Z

3

In the statement

DateTimeOffset.ParseExact("08/12/1992 07.00.00 -05:00",
                          "dd/MM/yyyy HH:mm:ss zzz",
                          CultureInfo.InvariantCulture)

the format string uses : as separator for the time parts, but the data argument uses . as separator.

answered Sep 28, 2015 at 13:28

Codor

17.6k9 gold badges32 silver badges59 bronze badges

Collectives™ on Stack Overflow

Parsing a DateTimeOffset string in C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related