insert 语句插入时间，结果时间是1899年！！！！求救

Question

DateTime.Now.ToShortDateString()两边加单引号'

Answer 1

DateTime.Now.DateTime.Now.ToShortDateString()换成别的看看 你的sql有没有错

Answer 2

"insert into
table xxx
values('','',......,''," + DateTime.Now.DateTime.Now.ToShortDateString() + " )"应该是执行上面那句话吧

Answer 3

还有，如果你的事sql server 如果日期时间字段没有值，则默认如1900-01-01 00:00:00

Answer 4

两端加单引号
"insert into
table xxx
values('','',......,'','" + DateTime.Now.DateTime.Now.ToShortDateString() + "')"

Answer 5

"insert into
table xxx
values('','',......,'','" + DateTime.Now.ToShortDateString() + "')"

Answer 6

两端加单引号
"insert into
table xxx
values('','',......,'','" + DateTime.Now.DateTime.Now.ToShortDateString() + "')"

Answer 7

"insert into
table xxx
values('','',......,'',' + DateTime.Now.DateTime.Now.ToShortDateString() + ' )"应该是单引号滴

Answer 8

"insert into
table xxx
values('','',......,'','" + DateTime.Today + "')"

Answer 9

"insert into
table xxx
values('','',......,'','" + DateTime.Now.DateTime.Now.ToShortDateString() + "' )""嘿嘿，犯了个小错误

Answer 10

我完整的代码是
cmd.CommandText = "INSERT INTO PD_YW_XLXSJL_FB VALUES(3,1,'" + this.textBox_GH.Text + "','" + this.comboBox_GX.Text + "','" +
                                   this.comboBox_GTBT.Text + "','" + this.comboBox_JYBF + "','" + this.comboBox_JC + "','" +
                                   this.comboBox_JDZZ + "','" + this.comboBox_DDX.Text + "','" + this.comboBox_FJJQT.Text + "','" +
                                   this.comboBox_FHQJTD.Text + "','" + this.comboBox_JCKY.Text + "','yubin','" + DateTime.Now.ToShortDateString() + "')";这样子出错，....'yubin'," + DateTime.Now.ToShortDateString() + ")";没错，可就是1899年

Answer 11

如果你要存的当天的日期可以用这个
"insert into
table xxx
values('','',......,'','" + DateTime.Today + "')"