getting issue with conversion from string to DateTime

Question

I am getting issue while converting string to DateTime.

The value I am receiving as "08-26-2015 10:14:57.898Z".

I am trying to convert the above string to DateTime.

My Code:

DateTime.ParseExact(element.Value,"MM/dd/yyyy HH:mm:ss",CultureInfo.CurrentCulture);

Exception: String was not recognized as a valid DateTime.

@juharr -Even i tried with CultureInfo.InvariantCulture,i am getting same exception.My current culture ="en-US" — AMDI
– AMDI, Commented Aug 27, 2015 at 14:20
Then the problem is the date separator. For US and Invaiant it's a slash / and not a dash -. As others have mentioned you might want to use DateTime.Parse or Convert.ToDateTime instead or specify that you want dashes as the separator in the format. Also you need to specify the milliseconds and the Z at the end. — juharr
– juharr, Commented Aug 27, 2015 at 14:22

M. Nasir Javaid · Accepted Answer · 2015-08-27 14:23:24Z

2

You have string with different format than you trying for conversion.

Try this

var input = "08-26-2015 10:14:57.898Z";
var date = DateTime.ParseExact(input, "MM-dd-yyyy hh:mm:ss.fff'Z'", CultureInfo.InvariantCulture);

edited Aug 27, 2015 at 14:23

answered Aug 27, 2015 at 14:19

M. Nasir Javaid

6,0087 gold badges40 silver badges58 bronze badges

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

2 Comments

to StackOverflow Over a year ago

Better to use CultureInfo.InvariantCulture, in case the current culture is using a time separator other than colon (:)

M. Nasir Javaid Over a year ago

@Joe Thanks for suggestion :)

Tim Schmelter · Accepted Answer · 2015-08-27 14:25:28Z

2

You can use:

DateTime dt = DateTime.ParseExact("08-26-2015 10:14:57.898Z", "MM-dd-yyyy hh:mm:ss.fff'Z'", CultureInfo.InvariantCulture);

If you use CultureInfo.CurrentCulture(or null) the slash / has a special meaning. It is replaced with the current culture's date separator. Since that is not - but / in US you get an exception. Read

answered Aug 27, 2015 at 14:25

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Comments

Pomme De Terre · Accepted Answer · 2015-08-27 14:18:12Z

0

Have you tried Convert.ToDateTime ? I just tried with your string and it works fine :

var s = "08-26-2015 10:14:57.898Z";
var date = Convert.ToDateTime(s);

answered Aug 27, 2015 at 14:18

Pomme De Terre

3721 gold badge4 silver badges14 bronze badges

2 Comments

AMDI Over a year ago

--Still facing issue,tried with X-TECh solution and it worked

Pomme De Terre Over a year ago

Happy to know you found the solution :)

Dmitry VS · Accepted Answer · 2015-08-27 14:22:57Z

0

String s = "08-26-2015 10:14:57.898Z";
DateTime date;
DateTime.TryParse (s, out date);

Now date variable contains DateTime value you need.

answered Aug 27, 2015 at 14:22

Dmitry VS

6155 silver badges15 bronze badges

Collectives™ on Stack Overflow

getting issue with conversion from string to DateTime

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related