Experts Exchange connects you with the people and services you need so you can get back to work.

Convert DateTime String to Datetime

Hi i have a value coming from external

Am getting string value (07/03/2011 12:00:00 AM ) and i want to convert to DateTime and update the Database.

At present am trying below methods but still no go...

Option 1:DateTime myDateTime=System.Convert.ToDateTime(item.StartDate);

Option 2:

string strDateTime = sampledate; (when i use this "it shows Cannot implicitly convert type system.DateTime ? to String)
DateTime myDateTime = DateTime.Parse(strDateTime );

Please some one guide me what is the right way to convert

Sha1395

Asked: 2011-03-09

Advertise Here

1 Solution

LVL 29

Paul JacksonSoftware EngineerCommented: 2011-03-09

The error you say you're getting with option 2 implies that sampledate is already in system.datetime format

Sha1395Author Commented: 2011-03-09

even i thought the same but when i pass the value as it is to DB,i gotta an error can't convert type from string to DateTime.

LVL 29

Paul JacksonSoftware EngineerCommented: 2011-03-09

What code are you using to pass to the database

LVL 30

anarki_jimbelCommented: 2011-03-09

I believe you problem is simple.

string strDateTime = sampledate;

The sampledate variable is a DateTime variable, I believe, not a string. Therefore you need to convert it to string. E.g.,

string strDateTime = sampledate.ToLongDateString();

LVL 30

anarki_jimbelCommented: 2011-03-09

Also, always try to use "TryParse", not just "Parse":

string strDateTime = "10/03/2010";
                DateTime dateToSave;
                bool canParse = DateTime.TryParse(strDateTime,out dateToSave);

                if (canParse)
                {
                    // save the date
                }
                else
                {
                    // show error
                }

Open in new window

Sha1395Author Commented: 2011-03-09

Thanks for all your help.

Here is my code

when i try to pass here

changed the code like below

string strDateTime = item.StartDate (can't implictly convert type system.datetime?tostring)
DateTime myDateTime = System.DateTime.Parse(strDateTime);

still throwing error

Sha1395Author Commented: 2011-03-09

nothing worked me...but if i use the below code

DateTime strDateTime = System.Convert.ToDateTime(item.StartDate); its not showing any error

but i couldn't understand the value am getting is string or already am getting date time ?

Sha1395Author Commented: 2011-03-09

Right now am using the below code...it get in to "TESTOK"

DateTime strDateTime = System.Convert.ToDateTime(item.StartDate);
string conv=System.Convert.ToString (strDateTime);
DateTime dateToSave;
bool canParse = DateTime.TryParse(conv, out dateToSave);

if (canParse)
{
Console.WriteLine("Testok");
}
else
{
Console.WriteLine("Fail");
}

Sha1395Author Commented: 2011-03-09

This is the code

DateTime strDateTime = System.Convert.ToDateTime(item.StartDate);
 string conv=System.Convert.ToString (strDateTime); 
DateTime dateToSave; 
dateToSave = DateTime.Parse(conv);

Open in new window

Here is the below value am getting "dateToSave = {23/03/1992 12:00:00 AM}" but when it pass it to DB am getting error "Error Converting data type Char to datetime"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Convert DateTime String to Datetime

Join & Write a Comment Already a member? Login.

Featured Post