dim tstr1,tstr2 as string
tstr1="20030915 15:30:00"
tstr2="2003-09-15 17:30:00"
程序中有段sql查询语句需要这两个变量的值,但必须是日期的sqlstr = "select * from h_DataVlu where h_time Between '2003-09-15 15:30:00' and '2003-09-15 17:30:00'"
(就是上面的这两个日期)(h_time 是datetime类型的)
dccmd.CommandText = sqlstr
dccmd.CommandType = adCmdText
dccmd.ActiveConnection = dcconn怎样才能将tstr1和tstr2转化成sql中需要的时间类型的值
tstr1="20030915 15:30:00"
tstr2="2003-09-15 17:30:00"
程序中有段sql查询语句需要这两个变量的值,但必须是日期的sqlstr = "select * from h_DataVlu where h_time Between '2003-09-15 15:30:00' and '2003-09-15 17:30:00'"
(就是上面的这两个日期)(h_time 是datetime类型的)
dccmd.CommandText = sqlstr
dccmd.CommandType = adCmdText
dccmd.ActiveConnection = dcconn怎样才能将tstr1和tstr2转化成sql中需要的时间类型的值
sqlstr = "select * from h_DataVlu where h_time Between #" & tstr1 & "# and #" & tstr2 & "# "
SQL里面用CONVERT(Datetime,)函数
sqlstr = "select * from h_DataVlu where h_time Between #" & tstr1 & "# and #" & tstr2 & "# "