DateTime.ParseExact

re: DateTime.ParseExact

reedone816 — Mon, 05 Oct 2009 23:18:52 GMT

@Chris,

just like the example, @"yyyy\/MM\/dd HH:mm", exclude the second

btw. in visual studio 2008, you don't need the escape anymore, so you just do it like this (in vb):

dim getdate as date

getdate=DateTime.ParseExact("2004/05/31", "yyyy/MM/dd", Nothing)

and you change the null to Nothing, otherwise it will generate error, and remember no space in "2004/05/31"

re: DateTime.ParseExact

Chris — Fri, 18 Sep 2009 13:16:28 GMT

Hi ,

I have a similar problem in that I am trying to find the correct datetime.parseexact format for the us 12 hour format e.g 9/14/2009 12:00:00 AM

Do you know how i need to specify the format string to parse these?

Any help is greatly appreciated.

Thanks

Chris

re: DateTime.ParseExact

Sabastesy — Wed, 16 Sep 2009 20:08:14 GMT

nice

re: DateTime.ParseExact

Dani — Tue, 08 Sep 2009 08:59:58 GMT

thanks. this solved my problem

re: DateTime.ParseExact

Robert — Tue, 25 Aug 2009 00:08:37 GMT

Brilliant... Just what I was looking for to save me at the end of a long day...

re: DateTime.ParseExact

garfield — Thu, 30 Jul 2009 09:18:02 GMT

Thank you..

re: DateTime.ParseExact

Thomas Freudenberg — Thu, 14 Aug 2008 06:17:01 GMT

Mac, a) April has only 30 days, and b) your format string does not specify the seconds fraction. Following line works fine:

DateTime parsedDate = DateTime.ParseExact(

"2008-05-31T13:20:00:000",

"yyyy-MM-ddTHH:mm:ss:fff", null);

re: DateTime.ParseExact

Mac — Thu, 14 Aug 2008 05:42:40 GMT

I am parsing "2008-04-31T13:20:00.000"

Any idea what could be the format? i am using yyyy-MM-ddTHH:mm:ss but it does not work.

re: DateTime.ParseExact

Thomas Freudenberg — Thu, 10 Jul 2008 15:11:14 GMT

That's correct, because the watch window calls .ToString() to display objects.

re: DateTime.ParseExact

NewP — Thu, 10 Jul 2008 15:07:05 GMT

At my end dt = {7/10/2008 12:00:00 AM}

right after I execute

DateTime dt = DateTime.ParseExact("2008-07-10", @"yyyy-MM-dd",null);

in watch window. So ... what could it be?

I am pulling my hair on this ...

thanks ..I appreciate it.

re: DateTime.ParseExact

Thomas Freudenberg — Thu, 10 Jul 2008 14:07:10 GMT

NewP, ParseExact works as expected. I tried

DateTime dt = DateTime.ParseExact("2008-07-10", @"yyyy-MM-dd",null);

and dt has the correct values.

I assume that you convert the DateTime object to a string accidentally, which will the default format (like dt.ToString())

re: DateTime.ParseExact

NewP — Thu, 10 Jul 2008 13:10:04 GMT

I am not sure what I am doing wrong.

I am putting value in a datatable. Column type is DateTime.

nextRow[colIndex]= DateTime.ParseExact("2008-07-10, @"yyyy-MM-dd",null);

It always puts value in default format. So the resultant date that I see looks like "07/10/2008 12:00:00 AM"

I don't understand why.

any ideas?

Thanks

re: DateTime.ParseExact

Mitoman — Wed, 25 Jun 2008 15:41:10 GMT

I am trying to parse 200806251630 into date time, and i am kinda having problem with parsing it this way

re: DateTime.ParseExact

Rick — Fri, 14 Sep 2007 00:11:22 GMT

Thanks man!!!! solve my problem too.... 10q

re: DateTime.ParseExact

Thomas Freudenberg — Wed, 14 Feb 2007 11:30:41 GMT

Hato0be, it depends on your regional settings. For example on my machine I set the date separator to '-', so the code above throws a FormatException if the string to be parsed contains slashes.

re: DateTime.ParseExact

Hato0be — Wed, 14 Feb 2007 11:19:52 GMT

..sorry, i mixed up the command, it was..

DateTime.ParseExact("14/02/2007", "dd/MM/yyyy", null);

re: DateTime.ParseExact

Hato0be — Wed, 14 Feb 2007 11:15:27 GMT

For me, don't know why... but works fine and without escaping the slashes, the date was in other format but i think it's the same..

i used this command:

DateTime.ParseExact("2004/05/31", "dd/MM/yyyy", null);

re: DateTime.ParseExact

Anonymous — Thu, 26 Aug 2004 06:03:00 GMT

R U caught by M$ like a few others who don't blog anymore or what's going on Thoemmi?

re: DateTime.ParseExact

Anonymous — Fri, 06 Aug 2004 15:53:00 GMT

Thanks a lot! this solved my datetime problem :-)