I'm using c sharp and mysql.
when i'm trying to insert a date from DateTime type to date column in DB all i get is 0000-00-00
i'm parsing my DateTime like this : sessionDate.ToShortDateString()
but getting empty date ...
any help please
-
is the DB column Date or DateTime type?Zenwalker– Zenwalker2011-08-19 15:30:55 +00:00Commented Aug 19, 2011 at 15:30
-
What DB are you using and how are you entering the DateTime into the DB, show some more specific code.jcvandan– jcvandan2011-08-19 15:31:12 +00:00Commented Aug 19, 2011 at 15:31
-
You need to post more of your code on how you do the insert, but without any context it does look odd to convert a datetime to a string when the targetcolumn is dateEddy– Eddy2011-08-19 15:32:03 +00:00Commented Aug 19, 2011 at 15:32
-
the column is in a type of "Date" the insert is by "insert to DB query" where i'm sending a string of sessionDate.ToShortDateString() to the date columnIgal– Igal2011-08-19 15:33:37 +00:00Commented Aug 19, 2011 at 15:33
-
eddy - if i'm not parsing my date in c# then i'll send full date time to DB , aka "8/19/2011 12:00:00 AM" by parsing it i send "8/19/2011" instead, but mySql Date expecting "2001-08-19"... i also tried to "tostring it" by using "YYYY-MM-DD" format, but then i got an exception from DBIgal– Igal2011-08-19 15:38:24 +00:00Commented Aug 19, 2011 at 15:38
|
Show 3 more comments
2 Answers
MySql uses date in yyyy-MM-dd format,So U can overide the toString() method Of DateTime.Now property.
YourDate= DateTime.Now.ToString("yyyy-MM-dd");
2 Comments
Igal
it doesnt work, i get an exception : "Incorrect date value: '1984' for column 'sessionDate' at row 1" and i've no idea why 1984 is there... the date i'm insert is current date...
Ravi Gadag
Can You Post the Entire Code.. Will look at it. did u tried using BreakPoints to Explore the values???
Try this to format your date time to a string value that is acceptable to MySQL
String.Format("{0:yyyy-MM-dd}", sessionDate);
2 Comments
Igal
didnt work i'm getting next exception from DB : Incorrect date value: '1984' for column 'sessionDate' at row 1... i've no idea why 1984 is there... the date i'm insert is current date...
joelbyler
I think we'll probably need a larger snippet of your code. Its difficult to tell where the error is coming from by just looking at this little information. Can you give the table definition and also the entire block of code which you are using to try and insert the date in the database?