如何在数据库中插如时间类型的数据？

[zhzhhly]

sq = "insert into client(ClientName,Date)"
sq = sq + " values('" & Text1(0) & "', # " & datevar & " # )"
datevar 为时间类型，怎么表示这个变量才没错
？

[gdyaojie]

传入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函数转换

[of123]

ACCESS：
sq = "Insert Into client(ClientName,Date)" & _
" Values('" & Text1(0) & "',#" & _
Format(datevar,"yyyy-mm-dd") & "#)"

[gxsun]

Format(datevar,'yyyy-mm-dd hh:mm:ss')
to_date(datevar,'yyyy-mm-dd hh:mm:ss')

[LGYAN]

是Ａccess数据库的话：
sq = "insert into client(ClientName,Date)"
sq = sq & " values('" & Text1(0) & "', #" & datevar & "#)"
是ＳＱＬServer数据库的话

sq = "insert into client(ClientName,Date)"
sq = sq & " values('" & Text1(0) & "', '" & datevar & "')"

[sanyou98]

up