UC知道SQL 插入日期
来源：百度知道 编辑：UC知道 时间：2024/05/31 04:39:27
suiji=12234
set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = db
Command2.CommandText = "INSERT INTO dbo.no_join_id ( user_name , pass , jion_time) VALUES ('" & Replace(request("user_name"),"'","") & "'," & suiji & ",#" & now() & "#) "
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()
"INSERT INTO dbo.no_join_id ( user_name , pass , jion_time) VALUES ('" & Replace(request("user_name"),"'","") & "'," & suiji & ",#" & now() & "#) "
有问题么？
为什么插入不了
set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = db
Command2.CommandText = "INSERT INTO dbo.no_join_id ( user_name , pass , jion_time) VALUES ('" & Replace(request("user_name"),"'","") & "'," & suiji & ",#" & now() & "#) "
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()
"INSERT INTO dbo.no_join_id ( user_name , pass , jion_time) VALUES ('" & Replace(request("user_name"),"'","") & "'," & suiji & ",#" & now() & "#) "
有问题么？
为什么插入不了
INSERT INTO dbo.no_join_id ( user_name , pass , jion_time) VALUES ('" & Replace(request("user_name"),"'","") & "','" & suiji & "'," & getdate() & ")
应该是这样的吧?
你把那个NOW()改成getdate()就行了~~