sql数据库中有表,就一个字段(DATETIME)INSERT INTO Tb values(CONVERT(DATETIME,'" & Format(DTPFrom.Value, "yyyy-mm-dd") & "',120)总是出现转换错误(从字符川向日期转化失败)
这样 :INSERT INTO Tb values(CONVERT(DATETIME,'" & DTPFrom.Value & "',120) 也是请问哪不对?
这样 :INSERT INTO Tb values(CONVERT(DATETIME,'" & DTPFrom.Value & "',120) 也是请问哪不对?
DROP TABLE tb
go
create table tb(DATETIME DATETIME)
go
declare @strP varchar(50)
set @strP='2009-11-20 11:20:20'
INSERT INTO tb values(CONVERT(DATETIME,@strP,120) )select * from tb
INSERT INTO Tb values(CONVERT(DATETIME,'" & DTPFrom.Value & "',120) 少了一个括号,还是???
INSERT INTO Tb values(CONVERT(DATETIME,''" & DTPFrom.Value & "'',120)--要再加上一对引号试试
我想把一段日期,连续插入表中
DayNumber = DateDiff("d", x, y)
For k = 0 To DayNumber
SQL1 = "INSERT INTO Tb_rq values((" & Me.DTPFrom.Value & "' + '" & i & "))"
cnn.Execute SQL1
Next
结果在数据表中显示1905-6-6 0:00:00