求一条SQL语句

Question

日期和时间都用单引号，如：
（'001','" + DateTime.Now.Date + "','" + DateTime.Now.TimeOfDay + "')";

Answer 1

string str = "insert into table (id,date,time) values('001','"+DateTime.Now.Date+","+DateTime.Now.TimeOfDay+"')";试试看

Answer 2

DateTime.Now.ToShortDateString()使（2003-6-27 0：0：0）变为2003-6-27

Answer 3

string str = "insert into table (id,date,time) values('001','"+DateTime.Now.Date+"','"+DateTime.Now.TimeOfDay+"')";