C# : How to convert string to DateTime, where the string can have any of the standard datetime format

Question

I had posted a question on DateTime to String conversion, I got many satisfying answers for that .. so I thank StackOverflow very much ..
Here is one more problem of String manupulation, I am stuck with ..

I have to convert a string (from some external source) using C# code .. the string can have these expected format of DateTime ..

02/31/2009 01:59:59 24 hours format
02/31/2009 01:59:59 AM 12 hours format
2/31/2009 1:59:59
2/31/2009 1:59:59 AM
02/01/2009 01:59:59 AM
2/1/2009 1:59:59
and so on .......

I tried using DateTime(Convert.ToInt32(string_date.Substring(6,4)),Int,Int,Int,Int,Int,Int)
ie, By extracting the values of month, Day etc

But it doesn't work .. because I can't extract the values with substring perfectly .. as the length of string is Varying
I also have tried to extract the values referring the occurance of "/", "space" and ":" but it becomes bottle neck to derive with (non-)Occurrence of AM/PM

Only the length of Day, Month and Hours can vary ..

Community · Accepted Answer · 2017-05-23 10:30:47Z

23

You can use the DateTime.ParseExact overload that takes a list of formats:

private static string[] formats = new string[]
    {
        "MM/dd/yyyy HH:mm:ss tt",
        "MM/dd/yyyy HH:mm:ss",
        "M/dd/yyyy H:mm:ss tt",
        "M/dd/yyyy H:mm:ss"        
    };

private static DateTime ParseDate(string input)
{
    return DateTime.ParseExact(input, formats, CultureInfo.InvariantCulture, DateTimeStyles.None);
}

This will throw a FormatException if the passed string does not match any of the given formats. Notice that the formats expecting AM/PM should appear before identical formats without AM/PM ("MM/dd/yyyy HH:mm:ss tt" comes before "MM/dd/yyyy HH:mm:ss").

Update
As Henk points out in the comments, the same functionality is available when using TryParseExact which removes exception situation. Also, paired with nullable types this can be made a bit cleaner:

private static DateTime? ParseDate(string input)
{
    DateTime result;
    if (DateTime.TryParseExact(input, formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out result))
    {
        return result;
    }
    return null;
}

Now it will simply return a null reference if it fails to parse the input.

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Dec 11, 2009 at 7:49

Fredrik Mörk

159k31 gold badges296 silver badges349 bronze badges

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

4 Comments

Henk Holterman Over a year ago

This overload also exists for TryParseExact, no reason to let it come to an exception.

Fredrik Mörk Over a year ago

@Henk: thanks. I expected that but didn't find it. I now realize that I was only looking at TryParse...

Rookie Programmer Aravind Over a year ago

@Fredrik "return null" shows error .. as it is not type "DateTime"

Fredrik Mörk Over a year ago

@Aravind: note that the method in the last example has the return type DateTime? (note the question mark); this means that it is a nullable type, where null is a valid value.

Darin Dimitrov · Accepted Answer · 2009-12-11 08:01:48Z

8

Take a look at the TryParseExact method. Here's an example with the first case:

DateTime date;
// I changed 02/31/2009 to 01/31/2009 because the first is not a valid date
if (DateTime.TryParseExact("01/31/2009 01:59:59", "MM/dd/yyyy HH:mm:ss", null, DateTimeStyles.None, out date))
{
    // string successfully parsed => do something with the date
}

You could then keep a list of different formats and try to parse the string with all of them until you succeed.

edited Dec 11, 2009 at 8:01

answered Dec 11, 2009 at 7:42

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

1 Comment

Rookie Programmer Aravind Over a year ago

Is there any other EFFICIENT way .. ? I mean its painful to type THOSE MANY LINES as many Lines I have as options ..

Rookie Programmer Aravind · Accepted Answer · 2009-12-18 13:43:06Z

Here are all the possible formats ..

MM/dd/yyyy 08/22/2006

dddd, dd MMMM yyyy Tuesday, 22 August 2006

dddd, dd MMMM yyyy HH:mm Tuesday, 22 August 2006 06:30

dddd, dd MMMM yyyy hh:mm tt Tuesday, 22 August 2006 06:30 AM

dddd, dd MMMM yyyy H:mm Tuesday, 22 August 2006 6:30

dddd, dd MMMM yyyy h:mm tt Tuesday, 22 August 2006 6:30 AM

dddd, dd MMMM yyyy HH:mm:ss Tuesday, 22 August 2006 06:30:07

MM/dd/yyyy HH:mm 08/22/2006 06:30

MM/dd/yyyy hh:mm tt 08/22/2006 06:30 AM

MM/dd/yyyy H:mm 08/22/2006 6:30

MM/dd/yyyy HH:mm:ss 08/22/2006 06:30:07

MMMM dd August 22

yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2006-08-22T06:30:07.7199222-04:00

ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Tue, 22 Aug 2006 06:30:07 GMT

yyyy'-'MM'-'dd'T'HH':'mm':'ss 2006-08-22T06:30:07

HH:mm 06:30

hh:mm tt 06:30 AM

H:mm 6:30

h:mm tt 6:30 AM

HH:mm:ss 06:30:07

yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2006-08-22 06:30:07Z

dddd, dd MMMM yyyy HH:mm:ss Tuesday, 22 August 2006 06:30:07

yyyy MMMM 2006 August

Clover · Accepted Answer · 2009-12-11 07:45:13Z

0

DateTime dt1 = DateTime.ParseExact("2007/01/01 04:23:12", "yyyy/MM/dd hh:mm:ss", System.Globalization.CultureInfo.CurrentCulture);

DateTime dt = Convert.ToDateTime("2007/01/01 04:23:12", System.Globalization.CultureInfo.CurrentCulture);

System.Globalization.CultureInfo.CurrentCulture format param

answered Dec 11, 2009 at 7:45

Clover

2661 gold badge4 silver badges14 bronze badges

Collectives™ on Stack Overflow

C# : How to convert string to DateTime, where the string can have any of the standard datetime format

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related