Parse datetime in multiple formats

Question

I have created an API end-point. The caller may call the API with POST method passing the relevant parameters. In the parameters there is one parameter that is of datetime format.

The problem is that when calling this API the caller may passes datetime in 3 different formats:

1. long int - e.g. 1374755180
2. US format - e.g. "7/25/2013 6:37:31 PM" (as string)
3. Timestamp format - e.g. "2013-07-25 14:26:00" (as string)

I have to parse the datetime value and convert it to a DateTime or string in Timestamp format.

I have tried using DateTime.TryParse(), DateTime.Parse(), Convert.ToDateTime() and Convert.ToDouble() but none of them are working in certainty for me.

The required output has to be in en-GB format.

Edit:

I had thought to have an if-else if-else block to use with TryParse 3 times with one else to say the string could not be parsed. Is this the best solution? Or are there solutions better than this?

Please help!

Answer 1

You should consider requiring a timezone. 1 doesn't need it, but #2 and #3 do.

public DateTime ParseRequestDate() {     // https://stackoverflow.com/questions/2883576/how-do-you-convert-epoch-time-in-c      CultureInfo enUS = new CultureInfo("en-US");      var dt = "1374755180";     //var dt = "7/25/2013 6:37:31 PM";     //var dt = "2013-07-25 14:26:00";      DateTime dateValue;     long dtLong;      // Scenario #1     if (long.TryParse(dt, out dtLong))         return dtLong.FromUnixTime();      // Scenario #2     if (DateTime.TryParseExact(dt, "MM/dd/yyyy hh:mm:ss tt", enUS, DateTimeStyles.None, out dateValue))         return dateValue;      // Scenario #3     if (DateTime.TryParseExact(dt, "yyyy-MM-dd hh:mm:ss", enUS, DateTimeStyles.None, out dateValue))         return dateValue;      throw new SomeException("Don't know how to parse..."); } 

EDIT As Matt Johnson points out, DateTime.TryParseExact accepts an array of format strings. 2 & 3 could be condensed.

public DateTime ParseRequestDate() {     // https://stackoverflow.com/questions/2883576/how-do-you-convert-epoch-time-in-c      CultureInfo enUS = new CultureInfo("en-US");      var dt = "1374755180";     //var dt = "7/25/2013 6:37:31 PM";     //var dt = "2013-07-25 14:26:00";      DateTime dateValue;     long dtLong;      // Scenario #1     if (long.TryParse(dt, out dtLong))         return dtLong.FromUnixTime();      // Scenario #2 & #3     var formatStrings = new string[] { "MM/dd/yyyy hh:mm:ss tt", "yyyy-MM-dd hh:mm:ss" };     if (DateTime.TryParseExact(dt, formatStrings, enUS, DateTimeStyles.None, out dateValue))         return dateValue;      throw new SomeException("Don't know how to parse..."); } 

The epoch conversion I borrowed from another question. (An extension method)

public static class MyExtensions {     public static DateTime FromUnixTime(this long unixTime)     {         var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);         return epoch.AddSeconds(unixTime);     } } 

Answer 2

You are looking for the DateTime.ParseExact (MSDN Article)

Which you would use in a situation like this:

string[] formats= { "MM/dd/yyyy hh:mm:ss tt", "yyyy-MM-dd hh:mm:ss" } var dateTime = DateTime.ParseExact("07/25/2013 6:37:31 PM", formats, new CultureInfo("en-GB"), DateTimeStyles.None); 

This allows you to add as many DateTime formats to the array as you need and the method will do the conversion without the if...else statements.

If your integer is in seconds since Unix Epoch you add the number of seconds to the DateTime of the Epoch (01/01/1970) (.Net doesn't have an out of the box method for this, but the logic is seconds since 'Epoch'):

new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(seconds); 

From this question.