Question

asp+access insert into 时间的问题

我的问题如下
数据库access 时间字段是长时间格式：hh:mm:ss，如17:50:00

定义的变量及表达式
dim ti_departure
ti_departure=cdate(request.form("ti_departure"))
response.Write(ti_departure)

sql 语句："INSERT INTO biaoge (ti_departure) VALUES ("&ti_departure&",)

结果：
14:20:00
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '14:20:00' 中。

Answer 1

语句ql 语句："INSERT INTO biaoge (ti_departure) VALUES ("&ti_departure&",)
改为："INSERT INTO biaoge (ti_departure) VALUES (#" & ti_departure& "#)"
试一下

Answer 2

sql语句改成 INSERT INTO [biaoge]([ti_departure]) VALUES('"&ti_departure&"')

Answer 3

语句ql 语句："INSERT INTO biaoge (ti_departure) VALUES ("&ti_departure&",)
改为："INSERT INTO biaoge (ti_departure) VALUES (#" & ti_departure& "#)"
试一下