如何在数据库中插如时间类型的数据? sq = "insert into client(ClientName,Date)"sq = sq + " values('" & Text1(0) & "', # " & datevar & " # )"datevar 为时间类型,怎么表示这个变量才没错? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是Access数据库的话:sq = "insert into client(ClientName,Date)"sq = sq & " values('" & Text1(0) & "', #" & datevar & "#)"是SQLServer数据库的话sq = "insert into client(ClientName,Date)"sq = sq & " values('" & Text1(0) & "', '" & datevar & "')" 传入SQL中时候,可以用format格式化成标准的年月日小时分钟秒形式ACCESS: sq = "insert into client(ClientName,Date)" & _ " values('" & Text1(0).Text & "', # " & Format(datevar,"yyyy-mm-dd hh:mm:ss") & " # )"SQL SERVER or MySQL:把#换成单引号ORACLE:SQL语句中要用to_date函数转换 ACCESS: sq = "Insert Into client(ClientName,Date)" & _ " Values('" & Text1(0) & "',#" & _ Format(datevar,"yyyy-mm-dd") & "#)" Format(datevar,'yyyy-mm-dd hh:mm:ss') to_date(datevar,'yyyy-mm-dd hh:mm:ss') 如何优化自由移动Picturebox中的Image? 关于VB程序用setup factory打包的问题 请问高手,如何用VBA获取Word中Symbol字符的Unicode代码 HELP!!!1 谁有helpworkshop,如果有请发到[email protected],收到给分! 哪里有整套的界面控件下载?如优化大师那样的......(收到就送分) 能将窗体中各种分隔的控件有嘛? 求教 纯新手请教,如何将一段txt读入数组? 谁用过VB7.net,是不是不同于VB6,用什么区别?现在还有学VB6的必要吗? 如何动态加载菜单项 划线中怎么样让几个点用平滑的曲线连接起来?
sq = "insert into client(ClientName,Date)"
sq = sq & " values('" & Text1(0) & "', #" & datevar & "#)"
是SQLServer数据库的话sq = "insert into client(ClientName,Date)"
sq = sq & " values('" & Text1(0) & "', '" & datevar & "')"
ACCESS:
sq = "insert into client(ClientName,Date)" & _
" values('" & Text1(0).Text & "', # " & Format(datevar,"yyyy-mm-dd hh:mm:ss") & " # )"SQL SERVER or MySQL:
把#换成单引号ORACLE:
SQL语句中要用to_date函数转换
sq = "Insert Into client(ClientName,Date)" & _
" Values('" & Text1(0) & "',#" & _
Format(datevar,"yyyy-mm-dd") & "#)"
to_date(datevar,'yyyy-mm-dd hh:mm:ss')