VB中调用sql语句,如何往数据库插入日期类型(DateTime)的数据(紧急,谢谢)
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (2004-11-16,Yes,程序运行,p2,p1,p3,)"
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (2004-11-16,'Yes','程序运行','p2','p1','p3','')"
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (38307,'Yes','程序运行','p2','p1','p3','')"
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (38307,'Yes','程序运行','p2','p1','p3','')"
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (#11/16/2004,'Yes','程序运行','p2','p1','p3','')"
"insert into tblPlan_01 (Date,Run,Mode,Prg1,Prg2,Prg3,Prg4) values (#11/16/2004#,'Yes','程序运行','p2','p1','p3','')"
cn.execute("insert into tblPlan (Date) values (#11/16/2004#)")
以上插入方法都不行。
cn是adodb.connection类的实例,tblPlan是表名,Date是日期型字段,为什么执行会出错
要用SQL语句输入日期型数据应该用哪种格式?