Access里插入时间字段的SQL怎么写？

Question

Insert into mytable (TimeField) Values (#2004-3-17 9:00:00#);

Answer 1

转化成data类型试试
如果试现在的时间可以用Now

Answer 2

Dim postZT As String = txtZT.Text
                    Dim postLR As String = parset(TxtLR.Value)
                    Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("data\Plane_club.mdb")
                    Dim strCommand As String
                    ConnClub = New OleDbConnection(strConn)
                    'Dim AdapterClub As OleDbDataAdapter
                    'Dim dsClub As DataSet = New DataSet
                     strCommand = "insert into newpost(FTR,ZT,LR,FTSJ,ZHGXSJ) values ('"
                    strCommand += logUser.YHM & "'"
                    strCommand += ",'" & postZT & "'"
                    strCommand += ",'" & postLR & "'"
                    strCommand += ",'" & Now() & "'"
                    strCommand += ",'" & Now() & "')"
                    'AdapterClub.= strCommand
                    Dim cmdClub As OleDbCommand = New OleDbCommand(strCommand, ConnClub)                    ConnClub.Open()                     cmdClub.ExecuteNonQuery()
 
                    '关闭连接
                    ConnClub.Close()

Answer 3

ljmay168(軍) 兄
还是insert语法错误啊

Answer 4

試試這個
Insert into mytable (TimeField) Values (cdate('2004-3-17 9:00:00'));