Convert String dateTime of javascript to DateTime C#

Question

I have a string

Tue May 13 2014 00:00:00 GMT+0700 (SE Asia Standard Time)

I want to convert to DateTime in C#. I use:

Convert.ToDateTime and DateTime.ParseExact("Tue May 13 2014 00:00:00 GMT+0700 (SE Asia Standard Time)","ddd MMM dd yyyy HH:mm:ss GMT+zzzz",System.Globalization.CultureInfo.InvariantCulture)

but it is not work :(

Please help me solve this issue.

Thanks so much.

What is a "String dateTime of javascript"? Isn't that just a string? The format of the string created by javascript's [*Date.toString*](http://ecma-international.org/ecma-262/5.1/#sec-15.9.5.2) is specified to be implementation dependent, so don't expect it to be consistent across implementations (it isn't). E.g. I get "Thu May 29 14:59:32 UTC+1000 2014". — RobG, May 29 '14 at 04:58

score 0 · Accepted Answer · answered May 29 '14 at 05:06

Stripe off the end of the string and use this :

var Date = "Tue May 13 2014 00:00:00 GMT+0700";
var FormattedDate = DateTime.ParseExact(Date,"ddd MMM dd yyyy HH:mm:ss 
'GMT'zzz",System.Globalization.CultureInfo.InvariantCulture);

Hope this helps you. Cheers.

score 0 · Answer 2 · answered May 29 '14 at 05:07

You must remove the TimeZone ID to be able to use a standard C# formatter.

This example works fine (your date, without the TimeZone ID):

var myDateString = "Tue May 13 2014 00:00:00 GMT+0700";

Console.WriteLine(DateTime.ParseExact(myDateString,"ddd MMM d yyyy HH:mm:ss GMTzzzzz",CultureInfo.InvariantCulture));

Adil · Answer 3 · 2014-05-29T06:06:13.653

The problem seems to be string literal GMT and (SE Asia Standard Time). You have parse these literals as well You can use single quotes to treat as string literal in the DateTime string format.

For example you have (SE Asia Standard Time) in the date time string then you can wrap it in single quotes in custom DateTime format for GMT like '(SE Asia Standard Time)'.

DateTime dt = DateTime.ParseExact("Tue May 13 2014 00:00:00 GMT+0700 (SE Asia Standard Time)",
                    "ddd MMM dd yyyy HH:mm:ss 'GMT'zzzz '(SE Asia Standard Time)'",
                    System.Globalization.CultureInfo.InvariantCulture);

An Hv · Answer 4 · 2014-05-29T05:55:28.523

0

This my code:

  var registerDateString = "Tue May 13 2014 00:00:00 GMT+0700 (SE Asia Standard Time)";
  var timeZoneIndex = registerDateString.IndexOf("(", System.StringComparison.Ordinal);
  var timeZoneId = registerDateString.Substring(timeZoneIndex);
  var dateTimeString = registerDateString.Substring(0, timeZoneIndex - 1);
  var FormattedDate = DateTime.ParseExact(dateTimeString,"ddd MMM dd yyyy HH:mm:ss 'GMT'zzz",System.Globalization.CultureInfo.InvariantCulture);

Thanks for your help everyone.

edited May 29 '14 at 05:55

answered May 29 '14 at 05:49

An Hv

897
1
6
7

You can directly parse the datetime string you have including (SE Asia Standard Time) – Adil May 29 '14 at 06:10

Convert String dateTime of javascript to DateTime C#

4 Answers4