Question

vb 与sql 中的日期小问题

看：
Private Sub Command2_Click()
getday = Format(Text_arridate.Text, "yyyy-mm-dd")
Text1.Text = getday
Dim mysql As String
mysql = "update guests set arridate=('getday') where roomcode='102'"
myConn.Execute mysql
End Sub
TEXT1.text是我用来测试的，的确认里面能显示日期比如2007-11-24.
可是关键是text1.text怎么样才能录入到sql里的datetime型列表中？

Answer 1

mysql = "update guests set arridate='" & getday & "' where roomcode='102'"
myConn.Execute mysql

arridate最好设为字符型.