mysql插入时间字符串,在日期时间的C＃格式字符串中的MYSQL日期时间列插入

I have code like this:

AutoParkDataDataContext Db = new AutoParkDataDataContext();

Dailyreport dailyRep = new Dailyreport();

string time = Convert.ToDateTime("10-10-2014 15:00:00");

dailyRep.order_time = time;

Db.Dailyreports.InsertOnSubmit(dailyRep);

Db.SubmitChanges();

When I see it in the DailyReport table it shows me only the date ("10-10-2014 00:00:00:00"), so the time is ignored. How could i fix it?

The column type is DateTime.

解决方案

Your line:

string time = Convert.ToDateTime("10-10-2014 15:00:00");

Shouldn't compile.

I can only guess that you don't have DateTime as type of your column in SQL Server, you should modify it to keep DateTime and then pass a DateTime type object, not a string.