c#代码获取mysql时间,如何使用C＃代码在MySql数据库中插入DateTime

2/1/2009 5:04:15 AM

I get it from MySQL database and want to feed it in table from other where i get it.

But it not worked in C# but using gui it work.

How i can feed this date to MySQL database using C# code.

解决方案string dt;

string dt2;

DateTime date = DateTime.Now;

DateTime date2 = DateTime.Now;

dt = date.ToLongTimeString(); // display format: 11:45:44 AM

dt2 = date2.ToShortDateString(); // display format: 5/22/2010

cmd.Parameters.Add("@time_out", SqlDbType.NVarChar,50).Value = dt;

cmd.Parameters.Add("@date_out", SqlDbType.NVarChar, 50).Value = dt2;

cmd.Parameters.Add("@date_time", SqlDbType.NVarChar, 50).Value = string.Concat(dt2, " ", dt); // display format: 11/11/2010 4:58:42