asked on
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.
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
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.
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
C#
Last Comment
Sha1395
The error you say you're getting with option 2 implies that sampledate is already in system.datetime format
ASKER
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.
What code are you using to pass to the database
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
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.ToLongDateStrin
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.ToLongDateStrin
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
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(strD
still throwing error
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(strD
still throwing error
ASKER
nothing worked me...but if i use the below code
DateTime strDateTime = System.Convert.ToDateTime(
but i couldn't understand the value am getting is string or already am getting date time ?
DateTime strDateTime = System.Convert.ToDateTime(
but i couldn't understand the value am getting is string or already am getting date time ?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Right now am using the below code...it get in to "TESTOK"
DateTime strDateTime = System.Convert.ToDateTime(
string conv=System.Convert.ToStri
DateTime dateToSave;
bool canParse = DateTime.TryParse(conv, out dateToSave);
if (canParse)
{
Console.WriteLine("Testok"
}
else
{
Console.WriteLine("Fail");
}
ASKER
This is the code
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"
DateTime strDateTime = System.Convert.ToDateTime(item.StartDate);
string conv=System.Convert.ToString (strDateTime);
DateTime dateToSave;
dateToSave = DateTime.Parse(conv);
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"