How to Convert String Date in DateTime form in ASP.NET C#

Question

I have a string Date which is coming from Database I need to parse or convert that String Date in DateTime form. Sharing the data and code as of now sharing the date which is coming from DB

String Date="7/19/2010 7:34:43 AM";

// I am parsing in DateTime form by below code

Date= DateTime.Parse(Date).ToString("yyyy-MM-dd HH:mm:ss.fff");

But I am getting the error while parsing with existing code as String was not recognized as a valid DateTime. Can anyone please share some info how can I resolve this error so that I wont receive any exception

Note

Issue with my code is the date which is coming from Database is not a valid string type that's why I am getting the error string is not recognized as valid datetime

are you trying this "Date= DateTime.Parse(Date).ToString("yyyy-MM-dd HH:mm:ss.fff");" in code behind ? — Krunal Patil
– Krunal Patil, Commented Jul 1, 2014 at 5:49
yes Krunal It is existing code when I debugged I found it is failing — Rahul
– Rahul, Commented Jul 1, 2014 at 5:52

Sajeetharan · Accepted Answer · 2014-07-01 06:15:05Z

1

You should do, using DateTime.ParseExact

 DateTime dt = DateTime.ParseExact("7/19/2010 7:34:43 AM",
                            "M/d/yyyy h:mm:ss tt",
                            CultureInfo.InvariantCulture);

edited Jul 1, 2014 at 6:15

answered Jul 1, 2014 at 5:49

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

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

6 Comments

Rahul Over a year ago

hi Sajeetharan ,thanks for sharing ur code but when I tried ur code I am getting build error Error 102 Cannot implicitly convert type 'System.DateTime' to 'string'

Sajeetharan Over a year ago

@Rahul Try the modified one

Rahul Over a year ago

Thanks Sajeetharan now I am not getting error but I don't want to change the variable name I want to use the existing variable only

Sajeetharan Over a year ago

@rahul then just replace the variable, your history shows you dont accept answers, try to appreciate those who help you!

Rahul Over a year ago

String Date = "7/19/2010 7:34:43 AM"; Date = DateTime.ParseExact(Date,"M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture); When I am using I am getting error like cannot convert datetime to system.string and also I am not getting the time details for ex 7 Hours 34 Min 40 Sec AM

|

Arijit Mukherjee · Accepted Answer · 2014-07-01 05:50:14Z

0

DateTime.ParseExact(yourstring, "yyyyMMdd_HH:mm:ss.fff", new CultureInfo("en-US"));

Will solve your issue.

For reference follow :

Date Time Parse

Date Time Parse Exact

answered Jul 1, 2014 at 5:50

Arijit Mukherjee

3,8952 gold badges36 silver badges53 bronze badges

Comments

Krunal Patil · Accepted Answer · 2014-07-01 06:00:59Z

0

Either you can use

DateTime.ParseExact or DateTime.TryParseExact

This will allow you to specify specific formats. I prefer the TryParseExact as they provide good coding style for the casing error.

answered Jul 1, 2014 at 6:00

Krunal Patil

3,6745 gold badges24 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to Convert String Date in DateTime form in ASP.NET C#

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related